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!

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

Like indicator applied to forms variable in query

Status
Not open for further replies.
AvGuy

AvGuy

Programmer
Jan 8, 2003
126
US
I want to specify criteria in a query that comes from a form control using the Like operator. Only I want to limit the number of characters to 4, like this for a criteria statement:

Like Left(Forms!MyForm!MyControl,4)*

In other words, if the value in the control is 123456 I want to limit the criteria to 1234. I can't seem to find a syntax to make it go and, believe me, I've tried.

Any ideas?

AvGuy
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

C
  • Question
Query expression negative to a 0
Replies
6
Views
389
dhookom
dhookom
breezett93
  • Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
5
Views
188
Chriss Miller
C
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
282
OzFoxy
OzFoxy
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
887
strongm
strongm
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
587
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top