Apped Query Concatenate

[RebekahK20_pontiac via AccessMonster.com]

After much help from people here I am almost done muddling my way through a
new db i've been tasked to create.

I've got my table linked to an outlook inbox..

Now I have an Append Query filtering out the specific data I need to update
an existing table (much easier to read than the linked data)

Just wondering since the linked table brings in both emails per TaskID as
seperate records; if I create a Concatenate field, do I put it in the Append
Query or in the end table?

Basically I need both records that relate to the same TaskID to be on 1
record.

1st record
TaskID AssignDate etc..

2nd Record
TaskID AcceptDate AcceptBy

Need to look like

TaskID AssignDate etc AcceptDate


I found another post that had the concatenate formula

TaskID: Concatenate (SELECT TaskID FROM tblz_try2VendorTechTasks WHERE
TaskID=" & [TaskID] & 'ORDER BY TaskID")

- which I will try
but I need to figure out where to put it? in the Append Query itself or the
end results or edit the linked table, so when the data comes in the records
get combined, the Append Query can do it's job?

I think I just answered it myself - in the linked table would be easier - but
can someone confirm that for me?


Thanks for ALL the help I've received. You have all made learning access so
much easier & fun... (my boss would be laughing at me saying this is fun)

 

[Guest]

Does record one and record two have the same fields?
Post the fields structure, with field names, not just what you are looking
for in record one and record two.
Something like this --
TaskID AssignDate AcceptDate AcceptBy etc..
11 1/1/07 <Null> <Null> <Null>
11 1/1/07 2/2/07 Bill Smith <Null>
12 3/1/07 4/5/07 <Null> <Null>
12 3/1/07 4/5/07 Joe Smith Exec