Search results

I'm trying to count the number of Unique ClientURNs of Male or Females answering Yes to each question returned by this query. SELECT DISTINCTROW qry1MajorFilterClients.ClientURN, qry1MajorFilterClients.Gender, [1 Client Visits].[Housing-SeekingHousing], [1 Client Visits].[Housing-Repair], [1...

I've got a table [tblClients] and another table [tblClientVisits] linked to the client table by a foreign key [ClientNumber] In the [tblClientVisits] table I've got a large number of Yes/No Question fields. I'm selecting groups of Clients in a query by [Gender] and [VisitDate] and so a Client...

I have a query with the Field [FirstVisitDate]. I want to drive this query from a form and have created an unbound Field on my form called [StartDate]. In my query design, I can easily put something like > Forms![MyForm]![StartDate] to return all records with a [FirstVisitDate] greater than...

I have a table [tblClientVisits] related to a table [tblClients] by a [ClientID] foreign key. I have a number of Yes/No fields in [tblClientVisits]which are grouped into "categories". e.g. Category1Question1YesNo Category1Question2YesNo Category1Question3YesNo Category2Question1YesNo...

I've got a query I want to export [qryExport]. I want the user to be able to export the contents of the query to a CSV file to a location of their choice and for this to be run from a button on a form. Obviously I'm going to need to be able to specify save as CSV format in the underlying code...