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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using text in a text box in SQL select statement
Thank you all for your help! dhookom, that bit of code you've given me has done the trick! It's done exactly what i wanted and I can even put a text box reference in place of the '3'. You're a legend. Thanks again.- tomnott
- Post #8
- Forum: Microsoft: Access Forms
-
Using text in a text box in SQL select statement
I've been trying to do ranking column but can't work it out. Numbering the rows isn't as easy as i'd imagined either. Do you know a good way of doing this? My table name is qry_random_all_details, with the unique (although not primary key'd) field name is repair_number. There are about 350...- tomnott
- Post #4
- Forum: Microsoft: Access Forms
-
Using text in a text box in SQL select statement
Thanks for the rapid response! I dont know DAO code (is it easy to pick up? because it sounds pretty useful?) but your other option has intrigued me. I ideally need a percentage but that's easy enough to sort out using another invisible text or with a formula here and there. Thanks for the...- tomnott
- Post #3
- Forum: Microsoft: Access Forms
-
Using text in a text box in SQL select statement
Hi All, I'm so heavily frustrated by this puzzle. Normally, i find answers on these forums so quickly and easily, or at least ones i can amend to suit my needs but this has really got me. I have a text box on my form, and what i'd ideally like to do, is to use the value in that text box (which...- tomnott
- Thread
- Replies: 8
- Forum: Microsoft: Access Forms
