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"?
Mar 18 2008, 03:15 PM
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).
Mar 18 2008, 03:48 PM
Roger; thank you.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.