Jim
---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 (2) |
Tidak ada komentar:
Posting Komentar