Say you have qry1 where a field was named "Full Address: CompleteAdd" to change the column title, then qry2 uses "Full Address" as a field, in code would you refer to the field in qry2 as "Full Address" or "CompleteAdd"?


Thanks,
rsmccli

If you use an alias (i.e. Full Address) in the query, you would use that in code if your record set is based on the query that contains the alias (i.e. qry2).

Roger; thank you.