Search results

Can someone tell me how to get this query to just show me the NUM_TAPE_MOUNTS from yesterday. The way it is now, it shows me many days wortj. I'm not quite sure how to alter the Count...... statement SELECT DISTINCT TESTSUMMARY.LIBRARY_NAME, TESTSUMMARY.DRIVE_NAME, Count...

This query works fine when run from Excel but when you put it into Access and run it, it gives an error on the hours statment. (see below) select distinct drive_name,count(*) as NUM_TAPE_MOUNTS from summary where activity='TAPE MOUNT' and CAST((current_timestamp-start_time)hours as decimal) <=...