yes, i tried the criteria with the actual value (it was "7"), i tried with "int" cause it is a number. Actually i do not understand why it works, but it's like life, never questioning why it works when it works
Competent Performer
Windows 10 
Access 2016
yes, i tried the criteria with the actual value (it was "7"), i tried with "int" cause it is a number. Actually i do not understand why it works, but it's like life, never questioning why it works when it works
VIP
Windows 10 Access 2007
Oh, no I am quite the opposite, wanting to know why.
So if you are searching for a number using a string or vice versa not good.
That infers Val() would work just as well?
Surprised you did not get a type mismatch?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Competent Performer
Windows 10 Access 2016
sorry for late answer. yes, val() works fine too
Constructing query with a search criteria for one column based on what is found in another column.
Query using multiple criteria to populate a new column
Return Value in Select Query based on criteria in another column of Query
Posting Permissions
Reply With Quote
