Select dates

  • Thread starter Thread starter Saintsman
  • Start date Start date
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
 
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
 
Back
Top