Recent content by GinaS

thank you plog, I finally got it, it's working correctly. I appreciate your help

Oh sorry, I must of missed a step, I thought once I changed all the fields to Standard Date format that it would automatically incorporate the date. Can you tell me what I'm suppose to do to include the date portion?

Thanks plog but this puts me back to the original problem of havine -1410 because one of the fields is past midnight. I'm thinking I might need a conditional 'IF' statement somewhere....your thoughts?

The problem with the negative time wasn't a problem until I fixed the midnight issue. So one fix resulted in a different problem. I think my original post was only concerned with fixing the midnight issue.

I'm dealing with patients that may start off with treatment prior to arriving at the hospital which result in a negative split and this is expected in my organization to make sure proper procedures are being followed: 1 - patient receives EKG (1ST_EKG) in ambulance at 10:00 pm 2 - ambulance...

I didn't use DateDiff - I wasn't sure how to use it with the +1 day. I used Format([arrived]-1-[1st_ekg], "Short Time"). I attached my database with the new results.

plog - WORKED like a charm!! Thank you. However, I do have one last question. With this calculation I can't report negative times. For instance, what is suppose to be -4 is now showing as 23:56, -12 show as 23:48. Is there a way to fix this?

Ok - Thank you plog, I will work on those changes and see what happens.

Thank you plog - it appears I may have some work ahead of me (capturing date in all the fields). I'm attaching a strip down version of my database to show what I have with the hopes of not having to redefine all the fields. In this version of my database I only included 2 queries. qryRptED shows...

Thanks plog - I may have a problem doing that because the form is designed to capture 13 different times from when the patient arrives to the hospital and then as they transition through the different departments like ER, LAB....etc. When designing the form the users stated they only need the...

Hello all, I am having a problem with calculating a date field in a query. Prior to this posting I've done some research and made several changes to my query. This only resulted in fixing one problem but then creating another problem. Original problem was I had 2 fields, arrived (23:36) and...

Hello, my name is Regina. I'm a programmer/analyst but I've mainly used programming languages and alot of SQL. I'm starting to use Access more and would like to learn more about some of the functions in Access. I look forward to learning and participating in this group.