Rosario
Posts: 54
|
| Posted: 08/13/2004, 7:24 AM |
|
Hi all,
I am trying to do a math function in a grid display but i am getting errors. I did a insert code on a new lable, trying to subtract time beteen 2 table fields that show. date
This is what i inserted:
DateDiff("h", [Timestamp], [last_modified]) & ":" & DateDiff("n", [Timestamp], [last_modified]) - (INT(DateDiff("n", [Timestamp], [last_modified])/60)*60)
Where last_modified is the end date and Timestamp is the start date. basicly trin to convert time to hours total.
This code works for access but here it says brackets are not allowed. Im lost please help. This calulation is fine under a quary but i am trying to make a grid output on a table with the calculation in a new field, so thats why i thought i might be able to just like a access quarry. hmmmmmmmmmmmm
|
 |
 |
|
