Using DCount to pull through specific data from the query

[Triacona]

Dear All,

Thanks for a great forum!!

I have a problem I have on one of my reports.

I have a report that pulls data from serveral queries.

The report: PS1

I am pulling data from the query: EnNoticesCases.

I am using the following code in a textbox to pull through my desired data.

=DCount("TNOT","EnNoticesCases","TNOT"="PCON_N")

So I want it to count the number of records in the TNOT field that have PCON_N as a criteria.

At the moment the output is 0, which is not true, because there are 2 records with the TNOT field which contain PCON_N

Any help will be greatly appreciated

Kind regards

Triacona

 

[Triacona]

DOH!!

Solved!!
hehe!

The solution is as follows:

=DCount("TNOT","EnNoticesCases","[TNOT]='PCON_N'")

Darn syntax!
I was missing declaring the field in brackets [], and declaring the comparison as a string "" and putting the string in the field as ''


Thanks all!
Kind regards

Triacona