reports between user defined dates

  • Thread starter Thread starter James
  • Start date Start date
J

James

I would like some help on creating a report on a list of
project milestones (data in table is: project name;
milestone note date; milestone notes). I have set up a
form that allows user to define project and start and
finish date of milestone notes. Reason being i manage
several projects and i'd like to be able to check updates
on specific projects individually within a certain range
(if desired). i can't figure out the query/report
structure to get the desired report.

thanks
James
 
You can reference the form controls in the criteria of your query like:
WHERE ProjectID = Forms!frmRptSelect!cboProjectID and NoteDate Between
Forms!frmRptSelect!txtStart and Forms!frmRptSelect!txtEnd
 
Back
Top