I think I missed something here - are you saying that you want to pull all records from a specific date, and then get the min, max and avg for some other column value. I assumed from your T-SQL that the column 'fAtmPM' was a date column. If that is incorrect, then remove the CDate() function from the SQL, and put a WHERE clause at the end specifying what day you want records from.

Otherwise, post more details or some sample data and I'm sure this can be worked out.