Search results

Does anybody have any idea how I can get the max value from the table with like condition? (first letters start with e.g 281)

Already tried it with Dmax(), and it helped to eliminate the error. But, I am getting another, strange: error 94, invalid use of Null

Hi there! I've got a bit of a problem with determining the max value in the table. I have a table called "Functions" and a column: "Function_KSW". There are values as follows: 281A01 421A01 281A02 etc. I want to get the max value of them but under the condition that first three chars are e.g...