dolano
2nd cousin of Rincewind
- Local time
- Today, 06:11
- Joined
- Jul 19, 2006
- Messages
- 28
Is there a way to set up a text/combo box so the user could enter a wild card search, for eg. at the moment there is a query where the field 'Route' has a criteria as follows Like "D???211", which is a pain. Now, there is a combo box which will get data from that field and from this a report will be generated. But, the middle 3 characters might not always be known or the user may want to see a range of results which incorporate the 1st and last 3 characters.
I would serperate out the field into its components ie "str", "str,int,int", "int,int,int" into a new table IF the template of that Route number was consistant, which it is not. There are values in that field such as 0.2 and Phase1, so can't seperate out the data into new table.
Is there another way around this issue.
Thank you for your patience.
I would serperate out the field into its components ie "str", "str,int,int", "int,int,int" into a new table IF the template of that Route number was consistant, which it is not. There are values in that field such as 0.2 and Phase1, so can't seperate out the data into new table.
Is there another way around this issue.
Thank you for your patience.