mellowyellow
New member
- Local time
- Yesterday, 22:11
- Joined
- Apr 18, 2006
- Messages
- 6
I have put together a fairly simple stock control database thanks to the help of an Access teaching book I have. I'm on the final hurdle, and that is creating Sales reports so the EndUser ( this is a school project ) can view past sales by week or month.
Here is my transactions table:
Here is the kind of report I would like to produce:
Fastest Selling Item of last seven days: ( eg Embassey x10 - 32 Sold )
Slowest Selling Item of last seven days: ( eg Sovereign x20 - 6 Sold )
Item Sales of last seven days:
* All producs with Sales figure for last seven days
eg:
Embassey x10 - 32 Sold
Malboro x10 - 30 Sold
... etc
Item Sales of last 30 days:
* All products with Sales for the last 30 days
eg:
Embassey x 10 - 110 Sold
Benson x10 - 98 Sold
What would be the simplest way of doing this?
Thank you in advance for any help!
Here is my transactions table:
Here is the kind of report I would like to produce:
Fastest Selling Item of last seven days: ( eg Embassey x10 - 32 Sold )
Slowest Selling Item of last seven days: ( eg Sovereign x20 - 6 Sold )
Item Sales of last seven days:
* All producs with Sales figure for last seven days
eg:
Embassey x10 - 32 Sold
Malboro x10 - 30 Sold
... etc
Item Sales of last 30 days:
* All products with Sales for the last 30 days
eg:
Embassey x 10 - 110 Sold
Benson x10 - 98 Sold
What would be the simplest way of doing this?
Thank you in advance for any help!
