Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I use variables in a query? 2

Status
Not open for further replies.

InkyRich

Technical User
Aug 2, 2006
126
GB
Hello,
I want to be able to use two global variables in the criteria row of a select query e.g. Between DateBegin And DateEnd.
Is this possible and if so what is the correct syntax?

Hope you can help.

Inky

A fool and his money are soon parted - so you might as well send it to me!
 
HI PHV,
Can you tell me if when you used the coding that you pasted on 20th June, (see 2nd entry)if you had trouble getting this to work as in this application it seems that Between does not want to work when calling up two functions.
Is that your experience or did it work for you?
I have to get to the bottom of this problem.

Regards

Inky

Hampshire UK.

A fool and his money are soon parted - so you might as well send it to me!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top