Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-19-2019, 08:23 AM   #1
vsk1975
Newly Registered User
 
Join Date: Mar 2018
Posts: 14
Thanks: 2
Thanked 0 Times in 0 Posts
vsk1975 is on a distinguished road
Dcount function in parameterised query

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.

vsk1975 is offline   Reply With Quote
Old 06-19-2019, 08:33 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,839
Thanks: 50
Thanked 1,103 Times in 1,084 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Dcount function in parameterised query

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.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 06-19-2019, 08:45 AM   #3
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,276
Thanks: 40
Thanked 3,653 Times in 3,523 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Dcount function in parameterised query

would also help for you to provide the SQL to your parameterised query - plus the dlookup you are using

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 06-19-2019, 08:48 AM   #4
vsk1975
Newly Registered User
 
Join Date: Mar 2018
Posts: 14
Thanks: 2
Thanked 0 Times in 0 Posts
vsk1975 is on a distinguished road
Re: Dcount function in parameterised query

Quote:
Originally Posted by theDBguy View Post
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

vsk1975 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Email parameterised report daviedaft Modules & VBA 2 01-05-2009 08:15 AM
Parameterised/Unparameterised Query gazsharpe101 Queries 8 02-14-2008 01:53 AM
Parameterised combo box on subform andygp40 Forms 2 02-07-2003 03:35 PM
DCount Function DaniBoy Reports 4 01-29-2002 06:37 PM
Dcount function with a query criteria??? chuckgoss Forms 1 08-08-2001 02:12 PM




All times are GMT -8. The time now is 08:42 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World