Dateserial

[gcorsey]

I have used a dateserial function to sum daily values. I would like it to sum it up by month, but it sums up the total over the years. Is there a way to get access 2010 to sum up just for a specific month?

 

[plog]

You would create a new field in your query like this:

MonthYear: Format([YourDateFieldHere],"mm-yyyy")

Replace "YourDateFieldHere" with the name of your date field. This will take the date and return a code with just the month and year (i.e. "01-2013", "12-2010"). Then underneath it, put in the month/year you want.

 

[gcorsey]

Wow! Thank you very much! You are the Man or Woman. I can not see your name to make that determination, but you ROCK!


Thank You