V vsk1975 Registered User. Local time Today, 23:44 Joined Mar 28, 2018 Messages 15 Jun 19, 2019 #1 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.
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, 10:14 Joined Oct 29, 2018 Messages 22,771 Jun 19, 2019 #2 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.
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.
C CJ_London Super Moderator Staff member Local time Today, 18:14 Joined Feb 19, 2013 Messages 17,754 Jun 19, 2019 #3 would also help for you to provide the SQL to your parameterised query - plus the dlookup you are using
would also help for you to provide the SQL to your parameterised query - plus the dlookup you are using
V vsk1975 Registered User. Local time Today, 23:44 Joined Mar 28, 2018 Messages 15 Jun 19, 2019 #4 theDBguy said: 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. Click to expand... sir as i am a learner in access un able to create a function, could you please provide such one thanks in advance
theDBguy said: 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. Click to expand... sir as i am a learner in access un able to create a function, could you please provide such one thanks in advance
