READ INPUT FROM ACCESS TABLE INTO A QUERY

[Gemini07306]

Hi Forum people,
I am fairly new in using Access. I need to create a couple of queries. This queries will extract dates from a particular period, but I do not want want to hard code the this date nor do I want to prompt for an input. Is there any way I could create a table with this date values and instruct my queries to access the dates from the table instead of keying in the date each time each query runs?
I have approximately 20 queries and do not want to prompt for, and input each date all the time.
Any help will be appreciated.
Thanks,
"Gemini07306"
Email: tgifgemini@yahoo.com

 

[ejc00]

i think the preferred way to do it would be to capture the date on a form... however, if you want the date to be in a table (warning: the table can have only 1 record in it), create a table (tbl_Date), and in one column have your date, let's call it Date.

in your query, create a join between your existing query/table and your table on the tbl_Date.Date field. this will limit your results to only those records which have the date listed in tbl_Date.