count number of inputs in field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field names status. In that field they can only enter accept or reject. In my report I want to give the total number of "accept" for my report. how is this done. I also want to do the same with reject but I wil just reverse the answer I receive.
 
Hi,

Use a Domain Aggregrate Function, example:

=DCount("[Status]","[Name of your table]",
"[Status]=Reject")

=DCount("[Status]","[Name of your table]",
"[Status]=Accept")

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: count number of inputs in field
| thread-index: AcROdIRZX4kbNhwtTEO+G19opyd0/Q==
| X-WBNR-Posting-Host: 208.2.28.132
| From: "=?Utf-8?B?dHJveQ==?=" <[email protected]>
| Subject: count number of inputs in field
| Date: Wed, 9 Jun 2004 15:53:01 -0700
| Lines: 1
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.reports
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.reports:140185
| X-Tomcat-NG: microsoft.public.access.reports
|
| I have a field names status. In that field they can only enter accept or
reject. In my report I want to give the total number of "accept" for my
report. how is this done. I also want to do the same with reject but I wil
just reverse the answer I receive.
|
 
I am new to codeing somewhat. I have tried this but it does not seem to work. What is the status for? Should I be putting something else in that area or?

Thank you very much for your help
 
In the report footer section, add a new control and set its source to
=Abs(Sum([Status]="Accept"))

That should give you what you are asking for as long as the Status field is a
text field which stores "Accept" or "Reject".
 
Back
Top