Hello!
I'm totally new to building databases with Access, and could use some help generating a report that, I think, should be pretty easy to get, I just don't know how to go about it. I have an inventory I manage, and I want a simple report to show exactly how many of each device type I have in inventory, pulling from 3 different tables (one for each device type). I use the "date shipped" field to track if the device is in inventory, meaning if it is blank, the item is currently in inventory.
What I would like to do, is create a report that says:
x number of device type A
x number of device type B
x number of device type C
Followed by something showing:
In the past 30 days x number of device A have been shipped (x in the past year)
In the past 30 days x number of device B have been shipped (x in the past year)
In the past 30 days x number of device C have been shipped (x in the past year)
Not sure if it's possible to do graphs, but I'd love to do something that looks a little nicer with graphing for the report. Thanks for any help you can offer!