hi all,
I have a report with the query1 in the control source
I have this textfield:
=COUNT([query2]![Date])
but when I open the report I got a msgbox want I enter the parameter for query2!Date
I suppose is cause by my second query but I dont know how to fix it.
can anyone help plz?
Hi all!!!
I have a table with a field "date" with this occurence:
"Date"
01/04/2004
01/04/2004
01/05/2004
01/05/2004
01/05/2004
01/06/2004
In my report I must calculate the number of the occurence, but only one time
so I need its write 3 but I got 6
I try =count([Date])
can anyone help...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.