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 :
---In MS_Access_Professionals@yahoogroups.com, <luvmymelody@yahoo.com> wrote :
---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;
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:
Posting Komentar