combine data from various fields into a single column

[smartascii]

Before I begin: I have searched the forums for a preexisting answer to this question, and if it's there, I haven't yet found it.

I have a database (about tracts of land) which pulls from various sources, and these are entered as tables. The data sources are not complete, however, such that Table A may not have an entry for a tract's acreage, but Table B might.

What I'd like to do is create a query that will look first at Table A, and if it finds an acreage, stop, fill that data into a column, and move to the next record. If it finds that the field is empty (or zero), Look at Table B, and if it finds an acreage, stop, fill that data into the same column as before, and move to the next record, etc.

I understand VBA scripting when I read it, and I can write simple things, but if the solution to this is code, I'll need some assistance creating it. Any advice or solution would be welcomed.

Thanks!

 

[John Big Booty]

Have a look at a Find Unmatched Query, you could then use the results in an Update Query.