Hi Ozair
You wrote:
> P.S. When I tried to post this question, I had been asked to "Join
>Group" ( I think I am already a member - still getting Daily Digest
>emails ).
Maybe you weren't signed in at the time. I've seen that prompt when my sign-in has expired.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "Ozair" <ozairkhalid@...> wrote:
>
>
> Hello,
>
> SELECT dbo_T_People.LastName FROM dbo_T_People
> WHERE (((dbo_T_People.LastName) Between 'ca*' And 'co*'))
> ORDER BY dbo_T_People.LastName DESC;
>
> The above query did not return many names which exist in the table.
> For example...
> LastName
> Cowgill
> Cowett
> Cowen
> cowell
> Cowdrey
> Cowart
> Cowan
> Covolo
> Covington
>
> HOWEVER if I alter the query [Between 'ca*' And 'cp*'] the missing records do show up.
>
> Please help and explain.
>
> Regards,
> Ozair
>
> P.S. When I tried to post this question, I had been asked to "Join Group" ( I think I am already a member - still getting Daily Digest emails ).
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar