How do I make access show repeated information?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm setting up a report that I want to show the following information in a
table format:

Item # Description Unit Est. Qty Actual Qty Cost Total Cost

I currently have an access table set up with the item #, description, unit,
and cost. I have another table that dictates which item # is needed and how
many. I want to be able to just key in an item # in the second table and
then have the report display the description, unit, cost for each item. I
want to set the table up to have room for multiple items, but I can only get
one item with a full set of details per query. I've tried a few things but
havne't had much luck. Any help would be appreciated.

Thanks
 
You should create a query with all of the fields you need. Then create a
Form with the fields you want to enter data for. Then you can enter data on
your form which will update your table/query. A report can be created if you
want to see the data in a report format.
 
I have a query that will get me the results for one item, and I can get that
into a report; its when I try to do this for a second item I have trouble.
This may make it more clear:

Item # Description Unit Est. Qty Actual Qty Cost Total
Cost
line 1 2.1 info ft 1 2
$2 $4
line 2 2.3 info in 3 2
$3 $ 6

I can get line 1 without any problem by adding item # and the Quantities to
the table I had created and then running a query to give me everything else,
complete with an expression for the total. I need this to repeat so I can
get the same results for line 2, line 3 and so on, up to about 10 lines.
Once I've run a query to obtain line 1, I can no longer retrieve any other
data from that table without running a second query. It seems very
inefficient to need to write 10 queries and then bring them into a report to
show this information, but I have not come up with a better solution as of
yet.

Thanks
 
Back
Top