DCount Function (1 Viewer)

[Petersen]

I’m trying to sum the number of “Yes’s” in a Yes/No field on a report.

1) In the footer of the report I created an unbound text field
2) I then went to Properties, Control Source, and typed in the DCount function as follows: =DCount([FieldName],"-1") ... no luck ...

I’m confused. Any help will be appreciated.

 

[MarionD]

Hi there,

Try =Dcount("*";"Same Table/query as your reportsource";"[Fieldname]=-1")

I'm not sure if you use semicolons or commas in an English Access? I work on a German system.

 

[Petersen]

No luck. I'm still getting an error. (English system ... used commas). Any other ideas?

 

[Jack Cowley]

=DCount("Y/NField","YesNoTable","Y/NField = -1")
Or
=Sum(IIF([Y/NField],1,0)

SPEBQSA - Did I remember that right?