Jumat, 18 Maret 2016

Re: [MS_AccessPros] Re: InString question

 

Jim


There are more expressions that can be used with LIKE. Check the web for lists.

-Bill


---In MS_Access_Professionals@yahoogroups.com, <luvmymelody@yahoo.com> wrote :

Bill

Why thank you. Never saw that before. That is awesome.


Jim Wagner


On Friday, March 18, 2016 10:31 AM, "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Jim

You could use a WHERE clause and no Table1.
WHERE [State License #] LIKE *[981-1000]*

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.microsoft.com/en-us/PublicProfile/35852?fullName=Bill%20%20Mosca
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <luvmymelody@yahoo.com> wrote :

Hello all,

It must be Friday, because I have drawn a blank to how to do this. I have a table of active vehicles and I am trying to find license plates that have certain numbers in the plate. I created a table named cnumber with the numbers from 981 to 1000 in the table as records. I was thinking of doing an instring, but 25 numbers seems a lot.

I created the query which is below but I am lost. Darn Friday.

Can anyone help me.

Thank You
Jim Wagner

SELECT AllActiveVehicles.Campus, AllActiveVehicles.[Dept Code], AllActiveVehicles.[Vehicle #], AllActiveVehicles.[State License #], AllActiveVehicles.Make, AllActiveVehicles.Model, Table1.cnumber
FROM Table1 RIGHT JOIN AllActiveVehicles ON Table1.cnumber = AllActiveVehicles.[State License #]
GROUP BY AllActiveVehicles.Campus, AllActiveVehicles.[Dept Code], AllActiveVehicles.[Vehicle #], AllActiveVehicles.[State License #], AllActiveVehicles.Make, AllActiveVehicles.Model, Table1.cnumber;
 


__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar