Filter data to show monthly/weekly hours

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access to make timesheets and Billing rates for clients. I was
wondering if there was a way to make a query that shows only the hours of the
employee for a specific month. I have the date function in my table i need
the query to show up for example only april w/ the hours that correspond.
 
You can create a form with two text boxes
Form: frmDates
Text Boxes: txtStart and txtEnd

Then in your report's record source query enter a criteria under the "date
function in my table" like:
Between Forms!frmDates!txtStart and Forms!frmDates!txtEnd

Your form must be open and values entered prior to running your report.
 
Back
Top