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.