Solved

Count Query using Multi-Valued Field

Posted on 2011-09-20
2
246 Views
Last Modified: 2012-08-13
Dear Experts,

In Access 2010 I am trying to build a query from which I can produce a set of stats (basic counts).  However the field I need to analyse is a multi-valued field.  (e.g. Commodities, Global markets, FX)

Is there a way using a simple IIF expression that will count the number of records where say "FX" appears somewhere in the field or some other means to perform the count

Many thanks

0
Comment
Question by:correlate
2 Comments
 
LVL 7

Accepted Solution

by:
shaydie earned 500 total points
ID: 36570579
Something like this?

SELECT Count(*) AS RecordCount
FROM TableName
WHERE (((MultiValueField.Value) Like "*FX*"));
0
 

Author Closing Comment

by:correlate
ID: 36573526
Perfect, thank you
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

As more and more people are shifting to the latest .Net frameworks, the windows presentation framework is gaining importance by the day. Many people are now turning to WPF controls to provide a rich user experience. I have been using WPF controls fo…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now