Web Development

Ask something
Discussion Locked

MS Access 2000 Reports/Functions

0 helpful
3 replies

by mra2

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I used the DCOUNT function in the code of a report. (Count1 = DCOUNT(field,domain,condition). Now how do I get the count1 variable on the report? When I use =count1, I get a parameter box asking for count1 instead of the result of the function.
Any help is greatly appreciated..... Alan

3 replies

by techrep

Put a textbox on the report. In the control source property for the textbox enter an equals sign followed by the Dcount syntax:

=DCOUNT(field,domain,condition)

For example:

=DCOUNT("Name", "Employees", "Sex='M'")

by mra2

Thanks!!! When my report opens a different filter is applied depending on the choice on a form that calls the report. Is there any way I can continue to use 1 report and get the number of checked boxes depending on the filter?
Thanks, Alan ABRAMOWITZA@coned.com

This discussion is closed to new replies.