How do I make a query i Access ? trying to add the title The O.C.

[Guest]

Trying to find all the programes named The O.C. in my database but it wond
finf anything using "The O.C."

 

[Guest]

I think I know what you mean.

Have you tried your criteria using "like"?

example:

Like "*" & [Enter in TV Show] & "*"

 

[Guest]

Thanks but that did not work

 

[Duane Hookom]

Jamie,
Try harder. Maybe instead of posting such a vague question, you should take
the time to explain what you have and what you need. We don't know anything
about your tables or fields.

Also, "did not work" is probably one of the most useless replies we get in
these news groups.

We can't see your computer screen and shouldn't have to make WAGs regarding
what you are thinking.

 

[John Spencer]

Try criteria
Field: Programme
Criteria: Like "*The O.C.*"

If that fails then try the following,
Criteria: Like "*The*O*C*"

If that fails to give you the records you want (and probably others) then
you need to check the data in the table. If you are searching against a
lookup field, then the actual values may be numbers that point to values in
another table.