info carries to all lines on report

  • Thread starter Thread starter karen
  • Start date Start date
K

karen

I am trying to set up a report to track inventory in and
out. When I print my inventory report in, it works
perfect. When I try to pull from both my in and out to
print a cumulative report, the same data appears on every
line of the in inventory, even if no inventory went out
in the group. How to I fix this so it only pulls info
with the same item number (my link). Thanks in advance.
 
Without information on what your table layout is, and what data you are
keeping, and what you mean by "pull from both", we aren't going to be able
to make useful suggestions.

At the least, we need to see the above, and the SQL for the RecordSource of
the Report that isn't working as you expect it to.

Larry Linson
Microsoft Access MVP
 
Larry:
I have 2 tables, linked by the item number. One table is
where I enter purchases (it has an auto number, item
number, description, units purchased, cost per unit). The
other is where I enter deletions (it has auto number,
item number, number of units removed, price per unit).
When I print my report, the purchases show up correctly
for each item. but when I put in a deletion for 1 item,
with an item number, the report deletes that many items
from each of the different items. It is not linking by
the item number and keeping the deletion related to one
specific item. My queries are working fine, They will do
calculations like I want them to do. It is just my
report. I can't provide the SQL as this is a work
project and I am at home and will be on vacation for the
next week. Any additional suggestions will be greatly
appreciated and implemented in one week. Thanks for the
future help.
 
We really have to know how you are doing what you're doing. Maybe you can
clarify enough that we can be of help: How is it that you "put in" a
deletion into the report if not via the Query that is the Report's Record
Source? Can you _describe_ the query that you use for the report? How is
your report arranged?

For a start, that table design is going to make it difficult... similar
information about the same "things" in two different tables... it appears
the only difference is that the table for deletions _implies_ a negative
sign on the "number of units removed" (and the cost/price will, of course,
differ)..

With your design, you may have to use a UNION or a UNION ALL query to
combine the information in a useful manner... in fact, you may first have to
create a Query against the deletions table to negate the "number of units
removed" and UNION that Quiery with the Purchases table.

MVP Allen Browne has good information on inventory applications at his site,
http://allenbrowne.com. (The actual inventory tips are linked, and reside at
http://members.iinet.net.au/~allenbrowne/AppInventory.html.)

Larry Linson
Microsoft Access MVP
 
Back
Top