SELECT max(modelNum) as modelNumber from tblm_model
If I want to select the max of one field from a table:
I canít find it when there is no record. I use isnull(rs.fields(0) or rs.fields(0) < 1
to test it, but canít find itís nothing. But later on, it will give me error invalid use of null,
how do I solve this problem? Any help is appreciated.