Dcount - Recordsource

's Computer Specifications

Does anyone knows whether it is possible
to use the recordsource of a report as the criteria
in the DCount function?

Thanks.

's Computer Specifications

No, it's not.

DCount (and all of the other domain functions) only accept the name of a
table or query as the 2nd argument.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Eric" <(E-Mail Removed)> wrote in message
news:4E638B2F-99A7-4262-87C6-(E-Mail Removed)...
> Does anyone knows whether it is possible
> to use the recordsource of a report as the criteria
> in the DCount function?
>
> Thanks.
>

's Computer Specifications

Thanks Douglas, I appreciate your feedback!

Eric.

"Douglas J. Steele" wrote:

> No, it's not.
>
> DCount (and all of the other domain functions) only accept the name of a
> table or query as the 2nd argument.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Eric" <(E-Mail Removed)> wrote in message
> news:4E638B2F-99A7-4262-87C6-(E-Mail Removed)...
> > Does anyone knows whether it is possible
> > to use the recordsource of a report as the criteria
> > in the DCount function?
> >
> > Thanks.
> >
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Report's recordsource = form's recordsource	Johnny Bright	Microsoft Access Reports	4	27th Nov 2007 10:21 PM
How can i use DCOUNT without getting error when DCOUNT returns null	vasal	Microsoft Access Form Coding	1	15th Dec 2004 09:48 AM
Problem with Reports recordsource= Forms recordsource	Alex	Microsoft Access Reports	5	13th Nov 2004 10:50 PM
Repot Recordsource same as Form Recordsource	Alex	Microsoft Access	1	13th Nov 2004 08:59 AM
Problem with Reports recordsource= Forms recordsource	Alex	Microsoft Access	0	13th Nov 2004 08:54 AM