Viewing database entries when setting parameters

[anthonyd]

I am new to ACCESS and apologize for the naivette of my question.

I am trying to set up a query that will show only entries that contain the
chearacters "CV" in a certain column. In SQL view, I have entred the
following:

SELECT ShipDetail.Product
FROM Invoice INNER JOIN ShipDetail ON Invoice.MasterShip =
ShipDetail.MasterShip
WHERE (((ShipDetail.Product) Like '%CV%'));

Unfortunately, when I go into datasheet view, it does not show any data
entries at all, though I know that there are several that match this query.
Messing around in design view could not help solve this problem. What am I
missing? Thanks in advance for your insight!

 

[Jason Lepack]

WHERE (((ShipDetail.Product) Like "*CV*"));

 

[anthonyd]

Thank you! Ah, those pesky syntax differences.

 

[John W. Vinson]

SELECT ShipDetail.Product
FROM Invoice INNER JOIN ShipDetail ON Invoice.MasterShip =
ShipDetail.MasterShip
WHERE (((ShipDetail.Product) Like '%CV%'));

Unfortunately, when I go into datasheet view, it does not show any data
entries at all, though I know that there are several that match this query.

Just a dialect difference. SQL uses % as a wildcard for any string of
characters; in Access you need to use * instead.

LIKE '*CV*'

will do the trick for you.

John W. Vinson [MVP]