DateDiff in a query

[Jim.H.]

DateDiff in a query


I am trying to calculate time difference between two time columns as follows in a query which has a few inner joins
Diff: DateDiff("h",[Table1.TimeStrat],[Table1.TimeStrat])
This gives problem, it is asking [Table1.TimeStrat] to be entered, where is the problem?

[pbaldy]

Try without the brackets or

[Table1].[TimeStrat]

As it is, it thinks the whole bit is supposed to be a field name, and it can't find it.

[Jim.H.]

Try without the brackets or

[Table1].[TimeStrat]

As it is, it thinks the whole bit is supposed to be a field name, and it can't find it.

Thank you. I removed the brackets, it turned into this.
Diff: DateDiff("h",[Table1].[TimeStart],[Table1].[TimeEnd])
It still asks me [Table1].[TimeStart], what am I missing here? This is query inner join many tables, would that have any impact?

[Jim.H.]

Thank you. I removed the brackets, it turned into this.
Diff: DateDiff("h",[Table1].[TimeStart],[Table1].[TimeEnd])
It still asks me [Table1].[TimeStart], what am I missing here? This is query inner join many tables, would that have any impact?

Resolved. Spelling problem on the table. Thanks.

[pbaldy]

No problemo.