Competent Performer
Windows 7 64bit 
Access 2013
In queryAB, I want to reference a field called "billRate" which appears in table1 and in query1 (query1 pulls billRate from table1 also, that's how the query ends up with 'billRate' as a field name).
In queryAB, how should I reference the "billRate" field? In queryAB, I plan on using "billRate" in a calculated field.
VIP
Windows 7 64bit Access 2010 32bit
Prefix with the source table or query name. Build in query designer and select field from the Field row dropdown. Access will supply the prefix.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Referencing Table Field Value to Change Back Color (with if/iif VBA/expression)
Count How Many times a value appears in a table
Posting Permissions
Reply With Quote