M
Michael
Hi, I just had a question about querying before putting something in a
report. Basically what I have is a table full of inventory that a user filled
out a form to input. This inventory can either be bought, sold, sent to
another part of the company, recievied from another part of the company, etc.
Each inventory item has about 6 characteristics that makes it unique from one
another. The user simply fills in these characteristics when filling out the
forms. Now I want to make material transfer reports, but rather than just
having these characteristics on the reports, they correspond to an inventory
code. I have already made a bunch of reports that just take the information
from the tables and gives a report for each primary key (in which they can
specify a date period in which they want to have come up). I am trying to
figure out how to put in the report the codes for the inventory. Rather than
having to make queries for each table (tables correspond to what type of
inventory transfer it was e.g. bought, sold, transferred, etc.) is there a
way of querying the data from the table the report is getting its records
from? I have a table of the inventory characteristics and the codes they
correspond to, but I just was wondering if I could easily input a textbox
into the report that would query the inventory code before each report was
brought up....Thanks for your help and ideas!
report. Basically what I have is a table full of inventory that a user filled
out a form to input. This inventory can either be bought, sold, sent to
another part of the company, recievied from another part of the company, etc.
Each inventory item has about 6 characteristics that makes it unique from one
another. The user simply fills in these characteristics when filling out the
forms. Now I want to make material transfer reports, but rather than just
having these characteristics on the reports, they correspond to an inventory
code. I have already made a bunch of reports that just take the information
from the tables and gives a report for each primary key (in which they can
specify a date period in which they want to have come up). I am trying to
figure out how to put in the report the codes for the inventory. Rather than
having to make queries for each table (tables correspond to what type of
inventory transfer it was e.g. bought, sold, transferred, etc.) is there a
way of querying the data from the table the report is getting its records
from? I have a table of the inventory characteristics and the codes they
correspond to, but I just was wondering if I could easily input a textbox
into the report that would query the inventory code before each report was
brought up....Thanks for your help and ideas!