How do I combine text fields in Access

[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

 

[Ken Snell]

You can use a function that will combine the values from the different
fields, using the date field to be the "key" that links the records
together; you then incorporate the function in your query that consolidates
the daily figures.

ConcatenateFieldValues
http://www.accessmvp.com/KDSnell/VBA_Functions.htm#ConcatFlds

 

[John W. Vinson]

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"

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

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