Hi all,
I'm returning to access after quite some time and discovering that I have forgotten how to do even basic stuff. I am starting to create a resourcing database that needs to be able to work with dates and times and perform calculations on them.
I need to work out the number of hours. I have two date/time fields Day_Start_Time and Day_End_Time. I want to calculate the difference between the two in hours and then multiply by the number of working days. I tried this: Number_Of_Hours: DateDiff("hh",[Day_Start_Time],[Day_End_Time])*[Number_of_days] but get #Func! when I run the query.
I'm probably missing something very basic (like a knowledge of Access) but can anyone help?
Thanks in advance
Kev
I'm returning to access after quite some time and discovering that I have forgotten how to do even basic stuff. I am starting to create a resourcing database that needs to be able to work with dates and times and perform calculations on them.
I need to work out the number of hours. I have two date/time fields Day_Start_Time and Day_End_Time. I want to calculate the difference between the two in hours and then multiply by the number of working days. I tried this: Number_Of_Hours: DateDiff("hh",[Day_Start_Time],[Day_End_Time])*[Number_of_days] but get #Func! when I run the query.
I'm probably missing something very basic (like a knowledge of Access) but can anyone help?
Thanks in advance
Kev
Last edited: