Recent content by SherriKilgore

I tried this but I need to be able to ignore the time portion of the date/time field. I can create a work around, was just hoping it was something simple I was over looking. Thanks for your help.

How can I convert a Date/Time field into a Date field?

Thank you for your help, I have resolved the issue. There was one record corrupt in the data.:)

Thank you so much, it is definately bad data. I have an identical query with a different data source and that query is working fine.

You are probably correct about the bad data, I am having to import data from many different sources for this. How can I trouble shoot to know if this is indeed the data itself?

SELECT tblFTHC.DEPT, tblFTHC.[CLOCK NBR], tblFTHC.[EMPLOYEE ID], tblFTHC.POSITION, tblFTHC.SHIFT, tblLunchPunchHistory.CLKOND, tblLunchPunchHistory.CLKOFD, Left([tblLunchPunchHistory]![CLKOND],Len([tblLunchPunchHistory]![CLKOND])-2)/24+(Right([tblLunchPunchHistory]![CLKOND],2))/(24*60) AS [CLOCK...

I have been running this query for several weeks with no issues. Today I am getting an error "Invalid Procedure Call". Does anyone know how to resolve this?

I created a macro to output a table as "txt" format, the results differ from using the "right'click export" method in that the macro txt is not delimited and the "export" method is . . . is there something special that needs to be done to get the same result as the "export" method?

How can I convert a number format into a short time format? For example 0.125 should equal 3am.

Sorry about the table not posting correctly. Emp Nbr Clock Out Clock On 123 301 319 162 1200 1220 194 1100 1120 246 1120 1139

I am trying to track how much time an employee is taking for lunch. Here is some more data. The clock out is what time the employee clocked out for lunch and the Clock On is what time the employee clocked back in from lunch. I need to convert the Clock Off and Clock On from text to time so I...

You are correct, 300 is 3am and 1500 is 3pm.

How do you convert text stored as 300 (which is 3 pm) into a time field?

Thank you, this works perfectly

Thank you so much, this works perfectly. :)