Search results

Thanks, Jack I'll give it a go

I have an application which filters records based on user input. At some points the user can select to see the results of a query that will subsequently be used as the basis for a report. When these results come up on the screen they are in datasheet form (they appear like an Excel spreadsheet)...

I would say the problem has to do with the fact that the term varX that you are using is enclosed within the quotations. Access cannot discern that this is a variable that you want to compare.try something like this: "...WHERE InvoiceNumber = " & varX & ";" I'm fairly sure this should work for...

I am using an SQL statement to create a temporary table that I am going to pare down based on some user criteria. My first SQL command places all of the records into the table based on a single criteria. My problem is that when I use the statement: INSERT INTO tbltemp SELECT...

I have a report that is based on a query that is based on an SQL statement that is generated by a QBE form. The QBE form allows multiple selections and the selections are stored in a string variable. How can I pass this string variable to the report so the user can see these selection criteria...