RE: Simple Select Query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Just a guess. Is there a chance that the data you are appending from a web
site may contain some leading spaces? Try updating your [Location] field.

UPDATE [yourTable]
SET [Location] = TRIM([Location])

HTH
Dale

--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"Ra" wrote:

I have a this table where users enter data using a entry form, and I have
data appended from a Web site. I have a field called Location. When I query
by location I only get the records entered thru the form, if I use the full
location name. If I use the Like function however, I get all the records.
Any ideas why, since I'd like to use a combo to select location.

.

Relevant Pages