Use Table field in query criteria

  • Thread starter Thread starter deeds
  • Start date Start date
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.
 
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

Querying between two dates doesn't work if Start and End are ident 10
Joining unrelated data in query 2
Formatting date gives bad results in query 2
Access Dcount (multiple criteria) 3
too complex query 5
Use Date as Query Criteria 4
Date criteria in query 6
Query using date range entered by user 2

Back
Top