Count Query using Multi-Valued Field

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

correlateAsked:
Who is Participating?
 
shaydieConnect With a Mentor Commented:
Something like this?

SELECT Count(*) AS RecordCount
FROM TableName
WHERE (((MultiValueField.Value) Like "*FX*"));
0
 
correlateAuthor Commented:
Perfect, thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.