How do I create a daily table from monthly data?

[kwb]

How do I create a daily table from monthly data? I have a monthly table and want to split it into a daily table by dividing each monthly value by the number of days in that month. I need this so I can compare the new daily values to other daily values.



Thanks!

[June7]

First you have to determine how many days in that month. Tricky. Need to create a field in query with an expression. Review http://support.microsoft.com/kb/210448