Recent content by dhess62

Done with this thread:)

That worked :) Thank you!!

START_TIME in this is in the form of 5/7/2009 12:59:30 AM. So how do it get it to just look at todays date?

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...

OK, I have the date issue solved, now all I need is to somehow get the number of tape mounts per day to show up in its own column. There is a field in the TESTSUMMARY table called NUM_TAPE_MOUNTS that needs to be used. Here is the code I have so far. SELECT TESTSUMMARY.START_TIME...

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) <=...