Select dates

S

Saintsman

I have 2 tables - Jobs & Projects. One job can have several projects (or none!)
Table 1 holds job details (jobid; jobenterdate)
Table2 holds project (jobid; projectid; projenterdate)
I need to run off monthly reports that pick up jobs & projects entered for
the month that picks up new jobs and new projects
This is driven by a user form where the date is selected (month & year)
How do I select records where jobenteredate and/or projenterdate = selected
date
 
D

Duane Hookom

It would help if you provided the form and date control names.

I expect your query would have a WHERE CLAUSE like
WHERE Format([JobEnterDate],"yyyymm") = Forms!frmA!txtYYYYMM Or
Format([ProjEnterDate],"yyyymm") = Forms!frmA!txtYYYYMM
 

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

Please suggest relationships model 36
Cartesian Help Please 5
Help With First attempt at Database Relationships 1
Need help With Inner Join Select Statement 3
need zeros! 3
Dates 2
Summing records selected in query 8
Summing groups in a report 1

Top