Recent content by JoysTick

Pat, Thanks for the reply, I'd reluctantly come to that conclusion myself, :-( What field/table structure would be better to normalize this situation? Thanks JS

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 (what I think) is a similar problem - 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...

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 similar problem, but I don't want to hard code the file path, I want to check for the existence of the file at a fixed location (c:\windows\Desktop\FileName.csv) and if it present then run an append to table query to add it's contents to a table. If it is not there, then I'd like to...

THanks JWindon, I think the second option would be better as I've already got lots of code hanging off the query. Can you be a bit more specific how this would work? How would ech of the combos be referenced in the QBE pane? TX

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...

Forgot to mention that I only really need the answer to this as a clculated control on a report, as I want to find out the total number of Unique Clients who ticked yes in any of the fields in each of the category. I'll need to do the calculation for each group of fields in the category and end...

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...