Copying many text fields into one test field

[Lee Cartwright]

Hi,

I am building a set of queries that will copy and update data from an
Access database into an Oracle 8 database. I am having trouble with one part
of the query. The database layout is something like this:

Incident table: Incident ID
Incident Note table: Note ID, Note Details, Incident ID Reference
Bug Table: Bug ID, Incident ID Reference, Dev Comments

Each Incident can have many Notes attached to it. All of the Notes for each
incident need to be placed into the Dev comments field on the corresponding
record in the Bug table as one entry. Any ideas or help on how to do this
would be appreciated.

Lee

[Joan Wild]

See
http://www.mvps.org/access/modules/mdl0008.htm
or more likely
http://www.mvps.org/access/modules/mdl0004.htm

Joan

"Lee Cartwright" <lee.car...@bull.co.uk> wrote in message
news:O7Frn7CNAHA.196@cppssbbsa05...