Solved

MS Access =count on Form

Posted on 2010-08-27
2
842 Views
Last Modified: 2013-11-28
I am trying to count all the records on my report that have "Yes" in "DutyAssigned" field.
I put =Count([DutyAssigned]=Yes) in the Report Footer and I get a total of all the records. I put it in Page footer and I get #error. What am I doing worng?
0
Comment
Question by:mekah
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 33540927
There is no expression of that type in Access.

Use..

Sum (iif(DutyAssigned =Yes, 1,0))

This assumes DutyAssigned is a Yes/No field in the table.

If it is just text then you need..

Sum (iif(DutyAssigned ="Yes", 1,0))
0
 

Author Closing Comment

by:mekah
ID: 33541294
Ah yes, I should have known that. Thanks for the help.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Add records to a form to a table 11 39
Need to Populate a MS Access Table via VBA Code 3 29
Filter a form 8 14
Switch 5 16
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question