Time/Date expression

[Dawn]

I am trying to create a query that looks for only items with a time greater
than 3:30pm. I created an expression to separate the time out of the
date/time field and applied criteria and this was working. However, now I
have added another table to the mix which also includes the same date/time
field. Therefore, I have to specify which table I want it to use for the
expression. Here is what I am using, but I'm not getting any results so it
must be wrong.

Expr1: TimeValue([dbo_tb_Defect]![InitiateDt])
Criteria - >TimeSerial(15,30,00)

Previously this worked when it looked like this:
Expr1: TimeValue([InitiateDt])

Any ideas??

 

[John Vinson]

I am trying to create a query that looks for only items with a time greater
than 3:30pm. I created an expression to separate the time out of the
date/time field and applied criteria and this was working. However, now I
have added another table to the mix which also includes the same date/time
field. Therefore, I have to specify which table I want it to use for the
expression. Here is what I am using, but I'm not getting any results so it
must be wrong.

Expr1: TimeValue([dbo_tb_Defect]![InitiateDt])
Criteria - >TimeSerial(15,30,00)

Previously this worked when it looked like this:
Expr1: TimeValue([InitiateDt])

Any ideas??

Try using . rather than ! to delimit the fieldname. ! is used for Form
or other object references, not for fieldnames.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps