Calculating Time

[Nikki]

Hi,

I would like to be able to calculate time within a
query. For example, what formula would a use to
calculate 8 hours before 10:00:00 PM. 10:00:00PM is a
variable and 8 hours is a constant.

Thanks,
Nikki

 

[Wayne Morgan]

For the field box in the design grid:

EarlierTimeateAdd("h", -8, [Table1].[Field1])