Help with Report

  • Thread starter Thread starter Dominique Schwartz
  • Start date Start date
D

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!
 
Try altering you dcount to below (watch out for wordrap)
=DCount("[fieldname]","[qryName]","[fieldname]" ='Criteria'")

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

--
Duane Hookom
Microsoft Access MVP


Jim/Chris said:
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!

.
Click to expand...
Click to expand...
 
Back
Top