UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Wildcard Query Problem    
 
   
nbatson
post Feb 1 2005, 02:46 PM
Post #1

New Member
Posts: 1
Greetings!

I am trying to write a simple parameter query to search a field containing "#123456" as the data format. I need to be able to find all that end in a given number. I believe that the wildcard in the field is causing me trouble. I have tried " like "[#] *" & [last digit]" , = "#" & "*" & [last digit], = "#" & "#####" & [last digit], and = "#" & "?????" & [last digit], all without success. Does anyone have any suggestions? Thanks!
Go to the top of the page
 
+
DoubleD
post Feb 1 2005, 02:59 PM
Post #2

UtterAccess Guru
Posts: 762
From: WI
Assuming you're looking for all ending in 6, this would work:

Right([FieldName],1) = 6
Go to the top of the page
 
+
mikewal
post Feb 1 2005, 03:44 PM
Post #3

UtterAccess Addict
Posts: 109
From: Tallahassee, FL
You could also use: like "#####6"

Mike
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 12:11 PM