[magusbuckley]

Hello:

I have an access dbase used to keep track of sales, inventory, etc. for a lady who sells crafts at local booths. I have a report that shows the total counts of types of items sold broken down by month.

For example, let's suppose she sells vehicles at this craft shows. In the report, I'm showing "January" for the month and then the types of items like "Trucks - 20 sold", "Cars - 13 sold", "SUVs - 7 sold", etc. And not that it matters, but just so you know, I am keeping track of sales of individual items so there is a report to break down these types, like "Cars", into actual products like "Camaro", "Eclipse", etc.

And now, here's the problem. Access is showing the months, but it's breaking them down by year. I'd like to combine "same" months no matte what year they are sold.

An example of what a report might look like right now....

January
Trucks - 20
Cars - 13
SUVs - 7

February
Trucks - 8
Cars - 10

January
Cars - 7
SUVs - 3

What's happening is Access is reporting for January of one year and then January again for another year. I'd like it to combine all January totals like this...

January
Trucks - 20
Cars - 20
SUVs - 10

February
Trucks - 8
Cars - 10

Is there any way to report all January's in one setting, no matter the year?

Thanks,

Brian

Edited by magusbuckley, 24 December 2012 - 11:44 AM.

[Advertisements]

Hi Brian,

Since you are not concerned with the year, use the Month function to grab the month from your Sold Date field and then group by this new expression instead.

Example: MonthSold: Month([tblVehicle]![DateSold]


Note: Replace tblVehicle with your database table name and DateSold with your field name.


Sample results:


Sounds like you may have second table for the Detail piece, but that will not affect the function.



Hope the above helps,

David

[dm27]

Hi Brian,

Since you are not concerned with the year, use the Month function to grab the month from your Sold Date field and then group by this new expression instead.

Example: MonthSold: Month([tblVehicle]![DateSold]


Note: Replace tblVehicle with your database table name and DateSold with your field name.


Sample results:


Sounds like you may have second table for the Detail piece, but that will not affect the function.



Hope the above helps,

David