Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pass Variable to DCount
- Thread starter dcurtis
- Start date
This seems like a controlsource in Access.
Then not directly, what you could do is create a public function to retreive the variable:
[tt]Public Function GetMyvariable() as <yourdatatype>
GetMyvariable = <name of variable>
End Function[/tt]
And then use the function name in the controlsrurce:
[tt]=DCount("[CountMe]", "data source", "[Critera] =" & GetMyvariable())[/tt]
- use appropriate qualifiers for the criteria (' for text, # for dates)
Roy-Vidar
Then not directly, what you could do is create a public function to retreive the variable:
[tt]Public Function GetMyvariable() as <yourdatatype>
GetMyvariable = <name of variable>
End Function[/tt]
And then use the function name in the controlsrurce:
[tt]=DCount("[CountMe]", "data source", "[Critera] =" & GetMyvariable())[/tt]
- use appropriate qualifiers for the criteria (' for text, # for dates)
Roy-Vidar
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question