Wildcard Help!

[Guest]

i have a table with a select query, one of the columns has data for example
the reference ab1234a or ba1234d, i am wanting to filter and only show the
items that begin with the first letter A but as the query also has the letter
a in the reference at another point it is extracting these entries as well,
where i am only interested in the items that begin with the letter a

any help greatly appreciated

 

[Klein-4]

i have a table with a select query, one of the columns has data for example
the reference ab1234a or ba1234d, i am wanting to filter and only show the
items that begin with the first letter A but as the query also has the letter
a in the reference at another point it is extracting these entries as well,
where i am only interested in the items that begin with the letter a

any help greatly appreciated

If you use the criteria -- Like "A*" -- that should do it.

Ross La Haye

 

[Guest]

thank you very much this has helped

If you use the criteria -- Like "A*" -- that should do it.

Ross La Haye

 

[Klein-4]

thank you very much this has helped







- Show quoted text -

You're welcome.

Ross La Haye