Merging repeating query results into one cell

[illdill]

I need to consolidate this data so that the values for 'Address' and 'City' are merged into one field or 'cell' according to the similar dates. This is a query result from two tables, one containing the Skip (Addres/City) information and another containing the Mileage and Route data. The query joins the data by the Date fields for both tables.

Please click the link to see the query results:

http://illdill.org/accesshelp/

Thanks

 

[ajetrumpet]

you can only merge your 'city' and 'address' fields in the same record. you cannot consolidate it any further using queries (with respect to the these two fields).

to join the two fields of data:

SELECT [city] & ", " & [address]
   FROM table...etc...

 

[illdill]

What I need is for the addresses with similiar dates to be merged into one data field.

 

[twoplustwo]

You could group by address I guess if you just want to display the address/city.

Then you'd have something like:

Address 1 City A
Address 2 City A
Address 3 City B

And so on.