Adding Fields

  • Thread starter Thread starter jlo
  • Start date Start date
J

jlo

I have multiple records with the same information except for one field
(Tracking No). I want to run a report that doesn't repeat the Weight and
Cost fields.

For example:

Co Name: Date: Tracking No: Weight: Cost:
ABC 1/2/09 1515 5.0 5.85
ABC 1/2/09 1516 5.0 5.85
ABC 1/2/09 1517 5.0 5.85

What I want is the report to reflect ABC with Weight at 5.0 and Cost 5.85.
I don't want to add the weight and cost fields.

Is that possible?

Thanks.
 
jlo,
In the query design, behind the report, remove the TrackingNo field from
the grid, and
then create a Totals query by slecting View/Totals, and using GroupBy on
each field.
Using that query, your data below would yield...

Co Name Date Weight: Cost:
ABC 1/2/09 5.0 5.85
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top