Anyone know MS Access well? Need help with a warehouse inventory system.
#1
Anyone know MS Access well? Need help with a warehouse inventory system.
I'm trying to set up a report that will give me information on what is located in a crate/pallet. Right now I have two tables. One you input the crate and it's various information. The other table I have is for the various items we have. I have the two linked together by when filling out the information for the item you have to associate it with a crate/pallet that has already been entered.
Now I would like to be able to print a report. Basically what I would like to do is have a form where you select what crate you want to print the report for. That will then create a report where the top portion gives the information about the crate found in Table 1 and the bottom portion lists any item associated with the same crate found in Table 2.
The issue is, I have no idea how to do this. I've uploaded my database to my webspace. I was wondering if anyone would be able to help me handle this issue.
Links:
2007 - http://rossmoshinsky.googlepages.com...nventory.accdb
2000 - http://rossmoshinsky.googlepages.com...eInventory.mdb
Now I would like to be able to print a report. Basically what I would like to do is have a form where you select what crate you want to print the report for. That will then create a report where the top portion gives the information about the crate found in Table 1 and the bottom portion lists any item associated with the same crate found in Table 2.
The issue is, I have no idea how to do this. I've uploaded my database to my webspace. I was wondering if anyone would be able to help me handle this issue.
Links:
2007 - http://rossmoshinsky.googlepages.com...nventory.accdb
2000 - http://rossmoshinsky.googlepages.com...eInventory.mdb
Thread
Thread Starter
Forum
Replies
Last Post
cinergi23
Turbo Parts For Sale
0
08-20-2009 01:11 PM
Sinner
General Discussion
3
10-09-2007 07:12 AM
leed
General Discussion
7
12-08-2005 08:17 AM
spoon fed
General Discussion
83
12-10-2004 07:12 AM