How do I combine text fields in Access

  • Thread starter Thread starter Anja
  • Start date Start date
A

Anja

Hi,
I have a small database that keeps track of my mileage.
Every trip is recorded in one table with date, start odometer, end odometer
and a short description.

When I run the query that consolidate it into daily figures, the total miles
is calculated, NP - However I can not seem to combine the short into one
longer description. Most days there are more than one trip.
The descriptions to combine would be: "home to gas station and back home"
with home to aunt polly and back home" It would be fine if the combined
description is:" home to gas station and back home, home to aunt polly and
back home"

The problem is that it is the same field(column) but on two different records

Any assistance would be greatly appreciated
 
When I run the query that consolidate it into daily figures, the total miles
is calculated, NP - However I can not seem to combine the short into one
longer description. Most days there are more than one trip.
The descriptions to combine would be: "home to gas station and back home"
with home to aunt polly and back home" It would be fine if the combined
description is:" home to gas station and back home, home to aunt polly and
back home"
Click to expand...

You'll need a little easy VBA code to do this. There's a sample at

http://www.mvps.org/access/modules/mdl0004.htm
 
Back
Top