• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

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

0
correlate
Asked:
correlate
1 Solution
 
shaydieCommented:
Something like this?

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

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now