Solved How to do this (probably) simple query in Access for 365

biagrin

Thread Starter
Joined
Jan 1, 2006
Messages
140
Im using a simple table in Microsoft access for 365.

I need to run a query on the table to generate a report. This is probably a simple problem to those who know what they are doing.

The problem I am having is this:

In one of the fields in the table some cells have a single values and some have multiple values. For example the cells in the field ‘X’ might look like this

A;
A;
A;B;
A;B;C;
A;B;C;D;


When I try to query the table for cells that contain ‘A’, access returns results which show cells which contain ‘A’ ONLY. In other words, cells which contain both ‘A’ and ‘B’ are not returned. I want the query to return all cells in the field which contain ‘A’ whether alone or with any other value.

Can anybody help on this?
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top