Transactions Report

[limcalvin]

Hi I was wondering if the following is possible to be done in Access 2007 and if so, how:



Basically I'm in a department that always has a lot of repetitive tasks during certain periods of time.

The tasks I do have a certain group of items I require to use.

I am required to print out a list of items of which I've to use for a certain period of time to submit.

Could it be possible that I could simply enter some data (i.e. enter 2 or more certain task) and I then generate an overall report of what items I've to use?

[rpeare]

Yes, but you would have to have a database where the larger task has the items you need for to complete it.

For instance

tblTasks
TaskID TaskDescription
1      Wrapping Presents
2      Washing Clothes

tblEquipment
EquipID EquipmentDescription
1       Laundry Detergent
2       Dryer Sheet
3       Tape
4       Box
5       Scissors
6       Wrapping Paper

tblTaskEquip
TEID TaskID EquipID Qty
1    1      3       1
2    1      4       4
3    1      5       1
4    1      6       2
5    2      1       1
6    2      2       2

So that whenever you added a task to your list you could add up all the different items you needed and the quantities of those items.

[limcalvin]

Thank You for your assistance. How could I go about doing the above database?

[rpeare]

I'm not going to build the database for you if that's what you're asking. If you have a specific question we can help.