Recent content by abristow

I understand what your saying but would this require me to run the query everytime new data is added to the DB? I've tried running a query that looks similiar to: SELECT IF (Land Time < Launch Time, Launch Time - Land Time, Land Time - Launch Time) From "Table" but this does not work. I also...

The issue is that this data comes from various organizations with a standardized data sheet they fill out. I then copy and paste all their data from the excel sheet into an excel sheet with a macro enabled formatting button. From there I copy and paste it into Access which essentially mirriors...

Hello, I am not sure if this is the correct sub-forum for this post, but it seemed the most relevant of them. I am trying to subtract two columns with time values in 24 hour time format. Column A being "Launch Time" , Column B being "Land Time" and create a calctulated field. I am having some...