Show query per day by specific month

[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

 

[John W. Vinson]

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

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.