By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,102 Members | 967 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,102 IT Pros & Developers. It's quick & easy.

How do I make this report?

P: n/a
If anyone could shed some light on this it would be much appreciated.
I have a query that has these rows from an inventory database.
BIN, SEG, PARTNO, DESC, COST, ONHAND, COUNTED, VARIANCE, VALUEDIFF,
BINCOUNTEDIN

I'd like to make a report that has all the rows on one line. Then in
the line directly below, any information where PARTNO is repeated yet
with a different BINCOUNTEDIN, I'd like to show the BINCOUNTEDIN and
COUNTED. Then after those would be a total line showing the totals of
ONHAND, COUNTED, VARIANCE and VALUEDIFF. So all of PARTNO records that
were the same would be grouped into one segment..

BIN, SEG, PART., DESC, COST, ONH.., COUNT.., VARI.., VAL., BINCO.
xx3 1 p45r hose $4.23 8 2 -6 $25.38 xx3
5 xx2
Totals: 8 7 -1 $4.23
Thanks in advance...

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.