Jumat, 18 Maret 2016

[MS_AccessPros] InString question

 

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: luvmymelody@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar