From verticle collum to horizontal

[Liz]

Need to create a query where the information is stored
down a collumn to appear accros a row?

EG: Multiple days that a centre is open to be listed
accross/ grouped as one entry?

Will be using for mail merge.

 

[Duane Hookom]

It would have taken you very little to type a few records and desired
output into your message and it would have helped tremendously. If my WAG is
correct, you can concatenate multiple values together using a generic
function found in a demo at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[John Vinson]

Need to create a query where the information is stored
down a collumn to appear accros a row?

EG: Multiple days that a centre is open to be listed
accross/ grouped as one entry?

Will be using for mail merge.

Duane's suggestion is one excellent WAG; my particular WAG (Wild-*****
Guess) is that you might want a Crosstab query, with centers as the
"row header" and days of the week as the "column header". These can be
generated using the Weekday() function on a date/time field.