merging two fields

[brandon]

I need to create a query that will take a 3 character code from one query then merge that 3 character code from another table that has a different 3 character code. With those, I'd like one field with a 6 character code.



If it makes it easier, I can create a table that contains that first 3 character code that I need rather than a query.

This will solve a problem...we have 20 areas that we monitor out of 200 that have a 4 character code that rolls up to this 3 character code. I've run select/where statements to filter it down to the 20 we want. Then, there is another table of about 250 3 character codes that will need appended to that list of 20 3 character codes I get. I really need all 250 3 character codes to append to each one of the 20 to make 600 rows. Is that possible? What kind of query would I run?

[Flekrad]

Still very new to Access here, so apologies if this doesnt work. Could you create a new Query that uses your 3number code query and the second table , and instead of dragging the fields down into the query write
Code:[NameOfFieldFrom1stTabe]&[NameOfFieldFrom2ndTable]

[brandon]

I'm not sure what you mean. What kind of query are you suggesting I run?

[Flekrad]

Just a select query at 1st to see if it reads your data, and produces a list of the combined numbers.

[brandon]

sweet! that works thank you!

[Flekrad]

Excellent !! Glad to hear