Show query per day by specific month

  • Thread starter Thread starter joave
  • Start date Start date
J

joave

Hi all:

I have some data that I need to show. The query asks the user what month
and year the data is to show. I need the query to divide the total for the
month by the number of days in the month. How do I get the query to know how
many days per month and show the proper data (per day)?

Thank you in advance,

Dave
 
Hi all:

I have some data that I need to show. The query asks the user what month
and year the data is to show. I need the query to divide the total for the
month by the number of days in the month. How do I get the query to know how
many days per month and show the proper data (per day)?

Thank you in advance,

Dave
Click to expand...

The length of a month can be obtained using:

LengthOfMonth: Day(DateSerial([Enter year:], [Enter month:] + 1, 0))

You can use that expression in the denominator of an expression in your query.
 
Back
Top