Search results

I've got a form that is essentially a switchboard with a series of buttons that are a user journey through a process. Each button opens another form or report, some of these forms are a popup, others are a fullpage form, one button can return just a msgbox message if certain criteria are met...

I have a table with some data that looks like the below screenshot. I'm trying to work out a way of returning one s_id for each unique combination of discount_lookup, abilitiy_level_lookup, payment_installments and weekly_sessions. I've put red dots next to the s_id's that the query should...

I've got what I think is a fairly standard order/invoice system in db I look after for a children's club. This club has a term based fee for membership, and each term an order is generated for each parent containing the fee for each of the children they have attending. In the db this populates a...

Difficult to come up with a title that makes sense for this one. I'm sure there is an obvious and simple solution to this query, but it's evading my tiny brain... This query is part of some error trapping of a more complicated piece, but essentially what I am trying to get to is to identify...

I've got a continuous form that has three unbound textboxes, named "linked_swimmer1", "linked_swimmer2" and "linked_swimmer3" on. The form is a list of contact names and I am looking to display the people these contacts are linked to and but only show the unbound textboxes where there are...

Hi I have a table that has a (text) name field and five checkbox fields in it (representing days of the week Mon-Fri), which is part of a class booking system where people can pick which day(s) they want to attend. I need a way of counting the number of checkboxes each record has ticked in two...