I got a another problem I put this as scource in my generator expression of my textfield
=CpteDom("[Date]";"[annuel_date_02]")
=Dcount("field";"query2")
when I enter in my report in my textfield it write error
anyone know why?
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?
thx for the help but I have a another problem now
when I enter in my report access demand a parameter for ma second query...but I have no parameter to send
how canI use 2 query's in one report?
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.