Use Table field in query criteria

D

deeds

Just like using the Forms!FormName!FieldName....can I use that same logic
with Tables? I have a start and end date in two fields within a single
table. I would like the query to reference the StartDate field and the
EndDate field within that table. I don't want the user to have to have a
form open to run the query. Any ideas? Thanks.
 
D

Duane Hookom

If the table has one record and you don't need the query to be editable then
simply add the table to the query and add the start and end date fields to
the criteria.

If your query must allow edits, you could try DLookup() to return the dates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting date gives bad results in query 2
Access Dcount (multiple criteria) 3
Date criteria in query 6
Use Date as Query Criteria 4
Querying between two dates doesn't work if Start and End are ident 10
Joining unrelated data in query 2
too complex query 5
Create IN criteria from another table 1

Top