Rabu, 24 Oktober 2012

[MS_AccessPros] Need help with Subtotal Query

 

I have a requirement to analyze data by displaying a subtotal for 7 qty fields per month based on a date field (mm/yy). The subtotal row has to display at the bottom of each month in the datasheet view. I tried a Union Query, but I have to group the data off of three different fields which causes problems with the Union Query. Not sure what would be the best approach. Any help will be greatly appreciated!

v/r,
James Eggert

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
.

__,_._,___

Tidak ada komentar:

Posting Komentar