Collateing fields

[Idontknow]

I have a table linked to excel that in turn is down loaded from a web site. The table is a booking form with a number of fields that I want to collate i.e. Field 1 is “Member ” field 2 is “Guest 1” field 3 is “Guest 2” field 4 is “Guest 3” field 5 is “Guest 4” etc. I want to collect all the fields in to a field called “Diner” so I have a list of diners to place on a report and also use in a sub form. Can anyone help please?


Thanks

[ranman256]

What do you mean by collate?
Bring them into a table?
Bring all text in all fields into 1 field called Diner?
(if so, then) INSERT INTO tTargetTbl [DINER] SELECT ( [Member] & [Guest 1] & [Guest 2] & [Guest 3] as expr1) FROM xlFile
or as a virutal field in the query
[Member] & [Guest 1] & [Guest 2] & [Guest 3] as DINER

[Idontknow]

Thanks for your reply. Sorry I don’t think I explained myself correctly. What I need is that all the fields “Members” and “Guests” etc. will appear in a Combo Box as a single list that can be used to populate a form that is designed as a Dining Table plan. This in turn will produce a report that is printed and displayed at the event .

[ranman256]

You prob. need a UNION query that collects the Members, then the guests all in one

qnGuests&Mems =
select [members] from tbl
union
select [guests] from tbl


set the combo box to this qry: qnGuests&Mems

[Idontknow]

That’s done it. Thanks very much!