Merge Records

[Guest]

I have an ID that is unique that could show 7-14 times because of officehours
in
one table. How can I make all these entries in one feild in a report or query


Table1
ID LOCNUM DAY OFFICEHOURS1 OFFICEHOURS2
1 LOC1 M 9-5
1 LOC1 T 9-2 2-5
1 LOC2 M 10-12 1-5
1 LOC2 W 9-2
........... And so on for each day.

How can I put them all together in a report in one feild? or any other
solution that will make it presentable in a report.

Thanks

 

[Rick B]

In one field?

Show us what you want. Spell it out for us.

Rick B

 

[Guest]

I have a table that store provider office hours, one record for each day. I
would like to combine all records for one provider in one feild, to show them
in one report.

 

[Rick B]

Again, what would you wnat this to look like?

LOC19-59-210-129-2 <--- This is "one field".

9-5 9-2 10-12 9-2 LOC1 <----- So is this.

I can't imagine why you'd want this in one FIELD.

If I were you, I'd do it similar to the report you show in your original
post.

I also don't understand the ID being a "1" in each line of your original
post.

You would need to tell us the fields in your tabel and what each field does,
you'd then need to tell us what you'd want the report to look like. What
fields would you pull to the report? What order would you display them in?
Would you want to group them in a particluar way?

Pretend we can't see your database and that we have no idea how it is built.

 

[Guest]

Yes, basilclly waht u saying is right. But I want to combine them under on
field and group them under the ID number.