OK.. Simpler question

rdjohnso

Registered User.
Local time
Yesterday, 17:38
Joined
Feb 10, 2006
Messages
17
OK.. Simpler question on DCount / DLookup..??

2 part question....

I have setup a Query: "rdqry_AvgRate"
screenshot at:
http://www.lnrconsulting.com/misc/Query.jpg

Question 1) in the query I am requiring a parameter "[Org]"
Can I pass this param in my lookup in my cell property.
If I cant, how do I get a param to the query form the Function call?

Question 2) I am trying to figure out if I use DLookup() or
DCount() for each of my cells to get the AvgRate I need.
Which of these do I use and what syntax?

?? =DLookUp("[AvgRate]","rdqry_AvgRate","Org='GWHIS'")
?? =DLookUp("[AvgRate]","rdqry_AvgRate","[Org]='GWHIS'")
?? =DCount("*","rdqry_AvgRate","Org='GWHIS'")

Thx for the help, R
 
Last edited:

Users who are viewing this thread

Back
Top Bottom