G Guest Jan 19, 2005 #1 In the query view, what expression would I enter to delete out only numbers within a comments column? Any help is appreciated. P
In the query view, what expression would I enter to delete out only numbers within a comments column? Any help is appreciated. P
S Steve Schapel Jan 19, 2005 #2 Petra, This might work for you... Like "#*" Another idea would be to make a calculated field in the query, like this... Val([Comments]) .... and then put the criteria in this column:
Petra, This might work for you... Like "#*" Another idea would be to make a calculated field in the query, like this... Val([Comments]) .... and then put the criteria in this column: