Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Queries: query form by number

Status
Not open for further replies.

pfenton

Technical User
Jul 18, 2000
32
GB
I know this might sound a bit basic, but the method for querying for numbers in Access 95 is not working in Access 97 (eg) to search for all numbers beginning with a 1, I would have used 1*. <br>The problem is this doesn't seem to work for Access 97.<br>Any ideas?
 
It does work but you must be missing something else.<br>First of all how are you doing it, in a query? Using VBA code.<br>Is the data type a Text or a Number?<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
Problem solved!!!<br><br>Had to put commas around the 1* so I just used: Like &quot;1*&quot; and that was that!!<br><br>Cheers anyway!<br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top