Begins With Query

[Ed68]

Hi Guys,

Can anyone advise me whether there is a 'begins with' option I can add into the Criteria field when running a query....similar to the filter facility on excel.

I am building a query where I need to see more than just the first two numbers so cannot use the <> function.

I hope that this is clear and any assistance you can provide would be much appreciated.

Cheers,
Ed

 

[VicRauch]

If you mean (I don't know Excel that well) you want to start with number 15 and see all the numbers from there until 83, then you can use "Between 15 and 83" Of course 15 and 83 here are example numbers.
HTH,

 

[Norie]

Ed

You could use Like and wildcards.

For example try this in the criteria.

Like "A*"

That should return all records where that field begins with A.

If that's not what you are looking for more detail and/or an example might help.

 

[Ed68]

Guys,

Thanks for the responses.

Norie - That works great and really helps me - thanks a lot.

Ed

 

[Norie]

Ed

No problem, post back if you need further help.

Here's another example.

Like "[A-E]*"

That will return all records where the field begins with A,B,C,D or E.

 

[reeser]

Like "A*"

I did a search and found this topic. I used a couple of the expressions mentioned above and they worked perfectly for what I was needing.

In an attempt to learn more about Access, what is the signifcance of the * after the A? I know some of the other expressions I have used returned the results fine w/o it, but in this particular case, nothing worked until I put in the *.

Thanks

 

[VicRauch]

The * is a "wildcard". So, what you posted, Like "A*" means give me everything that starts with an A and is followed by anything.