Access Reports

[ComputerThug]

I am trying to create a report in Access that would count how many records has a “Yes” value in a specific field.

Thank You
To quote Robert De Niro in the movie A Bronx Tale, "there's nothing worse than wasted talent.".

 

[CaptainD]

Base your report off of a Query.

SELECT Count(yourTable.YesNoID) AS CountOfYesNoID, YesNo.[yes/no]FROM [YourTable]GROUP BY YourTable.[yes/no]
HAVING (((YourTable.[yes/no])=Yes));

I counted the ID field and set the search criteria to "Yes" under the Yes/No Field

 

[ComputerThug]

I used =sum and it produced a negative sum.
Yes = -1 and No = 0
Then I used the abs command to change the negative number.

This probably sounds silly to a programer.

Thanks
To quote Robert De Niro in the movie A Bronx Tale, "there's nothing worse than wasted talent.".