Dcount function in parameterised query (1 Viewer)

vsk1975

Registered User.
Local time
Today, 18:47
Joined
Mar 28, 2018
Messages
15
Sir
I have a report containing Dcount function which is bbased on a parameterised query. always it shows error result. please help to correct it
thanking you.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:17
Joined
Oct 29, 2018
Messages
21,357
Hi. What does the error say? Perhaps you can't use DCount() on parameterized queries. If so, you might have to create your own function to do the job.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 13:17
Joined
Feb 19, 2013
Messages
16,553
would also help for you to provide the SQL to your parameterised query - plus the dlookup you are using
 

vsk1975

Registered User.
Local time
Today, 18:47
Joined
Mar 28, 2018
Messages
15
Hi. What does the error say? Perhaps you can't use DCount() on parameterized queries. If so, you might have to create your own function to do the job.




sir as i am a learner in access un able to create a function, could you please provide such one thanks in advance
 

Users who are viewing this thread

Top Bottom