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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Specific data search problem
No, I understood what went before it, but thanks for the reminder anyway. Works fine, thanks for the help.- trima1
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
-
Specific data search problem
Thanks for your time on this. I am not quite understanding your answer. Should it look like Where Mid([SessionNum],1,(Instr([SessionNum],"("))) Like "*" & [Forms]![SundayPreRegFrm]![SessionNum] &"*" BTW, This is not my database. Just got thrown into the middle of a wierd situation. I am...- trima1
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Specific data search problem
Maybe if I explain what the data means, it might make more sense. The data in the table is shown as 3S(June 24-29) 3 = week number S = Session Type (June24-29) = date code (that I want to ignore) But some data has multiple week numbers 34P(June 24-July 4) But, when I use the expression...- trima1
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Specific data search problem
I have a simple query that uses a field on a form to filter my data. The data in the field looks like this, 3S(June 24-29) 3T(June 24-29) 34P(June 24-July 4) My criteria expression is simple: Like [Forms]!SundayPreRegFrm]!SessionNum]&"*" Everything looks fine if I am looking for a single...- trima1
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
