Hi -

I need help with building what's probably a simple query. Here's what I have:

Table A and Table B
Each with three fields ... the first two calling for the same data, the third being unique from Table A to Table B

I would like to populate Fields 1&2 of Table B with the data from Fields 1&2 from Table A, and then set the value of Field 3 of Table B to a specific value (will be identical for each record in Table B).

Any help here with building a query that will accomplish this would be greatly appreciated.

Thanks!