[AccessD] Comparing Tables

I have two tables. The first table contains a master list of wells. The second table contains a list of wells with automated test equipment. Only some of the wells are automated. I need to generate a list of all the wells with a flag field with a value of "A" if the well is automated and a value of "M" if it is not. I can probably do this with an unmatched query giving me a list of the manual wells and then another query to combine the second table and the results of this query but was looking for any ideas of a better way to do this.


Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.