Variables in Queries

[Anon]

I am working in Access 2000 and would like to execute multiple queries using variables (dates enter by user). Save the query answers as variables, which I will use for calculations to be placed in a report.

I have done this using Paradox for DOS! And I have done this using Paradox for Windows! However, I can not find any examples of this using Access 2000 and SQL.

[sarahk]

You might want to give some more info. Are you sending the query to Access from php? Is it just a text string, should be simple enough to find how Access wants it's date strings passed.

Microsoft VFP likes {01/01/2001} for example. No quotes.