Help with Report

[Dominique Schwartz]

I have designed a custom report for a database. I now wish
to get the information from my quieries into the report, i
need the information to be in the form of a count of
specified information from specific fields. For example I
have an Address field that is a drop-down box with three
selections, what I need to do is count the occurance of
each of the selections in the address field and place each
count into the appropriate area in the report. I tried
using =DCount("fieldname","qryName","Criteria") but keep
getting an error message when I preview the report. All
help would be greatly appreciated!

 

[Duane Hookom]

What is your actual control source?
What is your actual error message?

 

[Jim/Chris]

Try altering you dcount to below (watch out for wordrap)
=DCount("[fieldname]","[qryName]","[fieldname]" ='Criteria'")

Jim

 

[Duane Hookom]

You have an extra double-quote following the second [FieldName].

--
Duane Hookom
Microsoft Access MVP

Try altering you dcount to below (watch out for wordrap)
=DCount("[fieldname]","[qryName]","[fieldname]" ='Criteria'")

Jim

-----Original Message-----
I have designed a custom report for a database. I now wish
to get the information from my quieries into the report, i
need the information to be in the form of a count of
specified information from specific fields. For example I
have an Address field that is a drop-down box with three
selections, what I need to do is count the occurance of
each of the selections in the address field and place each
count into the appropriate area in the report. I tried
using =DCount("fieldname","qryName","Criteria") but keep
getting an error message when I preview the report. All
help would be greatly appreciated!

.