Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Need Access to combine months on report.


  • Please log in to reply

#1
magusbuckley

magusbuckley

    Member

  • Member
  • PipPipPip
  • 625 posts
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.

  • 0

Advertisements


#2
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 272 posts
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]

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


Sample results:
Results.jpg

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



Hope the above helps,

David
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP