nono

Posts: n/a

Adding Sum

I made a query report with unique records to display,I don't want repeating
item displayed in the report.
What should I do to sum the other qty delivered in a single item.

Item Qty Date
Pork 50 08/01/05
60 08/10/05
20 08/15/05

should be

Item Qty Date
Pork 130 08/01/05 - 08/15/05

thanks & Godspeed.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
help neede with adding times	rvnwdr	Excel Discussion (Misc queries)	1	June 17th 05 02:15 PM
adding summed cells in a conditional sumif	Tat	Excel Worksheet Functions	5	June 12th 05 06:09 PM
problem adding	rvnwdr	Excel Discussion (Misc queries)	2	June 8th 05 06:36 PM
Adding up Sums	AlyG	Excel Worksheet Functions	3	June 7th 05 06:31 AM
adding only positive numbers	Jacob	Excel Discussion (Misc queries)	2	November 30th 04 12:24 AM

All times are GMT +1. The time now is 11:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us