Search results
-
A
Expression Builder for time subtraction help
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...- abristow
- Post #5
- Forum: Modules & VBA
-
A
Expression Builder for time subtraction help
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...- abristow
- Post #3
- Forum: Modules & VBA
-
A
Expression Builder for time subtraction help
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...- abristow
- Thread
- Replies: 5
- Forum: Modules & VBA