Conditional test to combine multiple records
- From: "Joe" <jhutchings@xxxxxxxxxxxxx>
- Date: 31 Jan 2006 06:45:54 -0800
Hello everyone,
I have a database where I collect shipment data from various tables.
However, I have a problem. Whenever I want to see shipping data for
orders that were set to ship on or before a certain date (in this case
January 30th) the database will return 2 rows for an order as you can
see below.
Order ID: Line: Due Date: Qty: Ship Qty: Part #: Shipped:
141285 1 1/30/2006 31 10 S15F-55 1/17/2006
141285 1 1/30/2006 31 21 S15F-55 1/27/2006
This is actually one order, that was shipped over the course of
multiple dates. However, I want Access to combine this information into
one record becaue I count the total number of shipped orders in another
query for use in a shippin report. This causes my report to have
incorrect data because it shows 2 orders instead of 1 that just shipped
over the course of multiple dates.
How can I combine these records if the following is true:
If Order ID, Line, Due Date, Qty, and Part # are all the same -
I want Access to combine these records into one line displaying the
greatest shipdate (in this case 1/27/2006).
So in the end, I want my result to look like this:
Order ID: Line: Due Date: Qty: Ship Qty: Part #: Shipped:
141285 1 1/30/2006 31 31 S15F-55 1/27/2006
.
- Follow-Ups:
- Re: Conditional test to combine multiple records
- From: John Spencer
- Re: Conditional test to combine multiple records
- Prev by Date: Re: Filter Report based on Selection from Form
- Next by Date: Re: Query does not show all data
- Previous by thread: INSERT INTO "record single"
- Next by thread: Re: Conditional test to combine multiple records
- Index(es):
Relevant Pages
|
