Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

ms access expression builder

Posted on 2009-05-17
Last Modified: 2012-05-07
trying to simply count records in a table [tickettable] that have the ticketstatus field set to Resolved

my expression--------------->    =Count([TicketTable]![TicketStatus]=["Resolved"])

but all i get is the lovely ERROR error message

i'm sure it is something simple.....thanks and 200 points to whomever can help me


Open in new window

Question by:rinkydink
  • 2
  • 2
LVL 13

Expert Comment

ID: 24408324
Why dont you use dcount instead.

=Dcount("Ticketsfield","tickettable","ticketstatus=" & resoloved & "")

Where are you going to use this expression? On a report or form or query?

Author Comment

ID: 24408360
i was trying to use it on an unbound text box on a form
LVL 13

Accepted Solution

lucas911 earned 200 total points
ID: 24409033
ok, if you have a resolved textbox or a check box then rename it to something meaningful.

then in your unbound text box  put in the dcount formula:

=Dcount("Ticketsfieldyouwantdisplayed","tickettable","ticketstatus=" & chResoloved & "")

Of course change the names to match your table and fields.  chResolved is a checbox field that is either true or false.

Author Comment

ID: 24409078

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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.

856 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