Current Month Report

J

JD

I have designed a data based about 3 technicians worked perforemed during
year, I like to display the total work done for each technician on a report
for the current month only. I have design a query to gather the information I
need for the report. My problem is, I need to display only data from the
begining of the month to the current date. I have used The following code
under criteria <Between [Enter Date] And Date()> But for this code I need to
enter the begining of the current month. I'm looking for help on this so as
to I do not have to enter any date, it will automatically will adjust every
month. Thank you in advance
JD
 
F

fredg

I have designed a data based about 3 technicians worked perforemed during
year, I like to display the total work done for each technician on a report
for the current month only. I have design a query to gather the information I
need for the report. My problem is, I need to display only data from the
begining of the month to the current date. I have used The following code
under criteria <Between [Enter Date] And Date()> But for this code I need to
enter the begining of the current month. I'm looking for help on this so as
to I do not have to enter any date, it will automatically will adjust every
month. Thank you in advance
JD
Click to expand...

As criteria on the Date Field:

Between DateSerial(Year(Date()),Month(Date()),1) And Date())
 
Top