UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Possible to refer to a query field by its "query name"??    
 
   
rsmccli
post Mar 18 2008, 02:49 PM
Post #1

UtterAccess Addict
Posts: 192
From: Iowa, USA
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
Go to the top of the page
 
+
jzwp11
post Mar 18 2008, 03:15 PM
Post #2

UtterAccess VIP
Posts: 4,236
From: Dayton, OH
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).
Go to the top of the page
 
+
rsmccli
post Mar 18 2008, 03:48 PM
Post #3

UtterAccess Addict
Posts: 192
From: Iowa, USA
Roger; thank you.
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 03:47 PM