Showing only one like record on a report?

Benjamin Bolduc

Registered User.
Local time
Yesterday, 20:02
Joined
Jan 4, 2002
Messages
169
Hi there,

Im currently working on a report that will give a complete inventory of all the Labels that I deal with. I have an inventory Form with all the different labels we have, and then a subform for entering the Inventory transactions.
Now in my report, I have it set up to calulate the current balances per Label, but for every Inventory Transaction entry I have, A new line appears. So I have 4 or 5 lines that say the same thing. Is there anyway to force it to only show one line per Label?
Any suggestions would be greatly appreciated, thank you
smile.gif
 
In design view go to View then Grouping and Sorting. Sort by lable and then have a group heading.

HTH
 
Actually, It is already grouped by Label name. The problem is that every inventory transaction for every label is being shown. I only want one Line per label, showing only the current balance.
I know there must be a way! thanks for your help
wink.gif
 
create a subreport, inserting the pertinent fields into the main report...showing the connection between records as necessary...
like one balance per every form id...

hope this helps...do this all the time...if you need more info...please holler
 
create a subreport, inserting the pertinent fields into the main report...showing the connection between records as necessary...
like one balance per every form id...

hope this helps...do this all the time...if you need more info...please holler
 

Users who are viewing this thread

Back
Top Bottom