Help me with this query

[Guest]

I hv this expression in my query

Expr1: DateDiff("d",[DATE_RECEIVED],Now())

How do i put some additional condition where field [status]="pending"

I''ve tried this

Expr1: DateDiff("d",[DATE_RECEIVED],Now()) where [status]="pending"

and its give me "headache"

Thanks

 

[tina]

Expr1: DateDiff("d",[DATE_RECEIVED],Now())

presumably the above is a calculated field in your query design grid.

add the "pending" criteria to the criteria line of the [status] field in the
query design grid.

hth

 

[Guest]

Thks for your reply..is it possible to include it in the calculated field
without having to add it in the query design grid

Expr1: DateDiff("d",[DATE_RECEIVED],Now())

presumably the above is a calculated field in your query design grid.

add the "pending" criteria to the criteria line of the [status] field in the
query design grid.

hth

I hv this expression in my query

Expr1: DateDiff("d",[DATE_RECEIVED],Now())

How do i put some additional condition where field [status]="pending"

I''ve tried this

Expr1: DateDiff("d",[DATE_RECEIVED],Now()) where [status]="pending"

and its give me "headache"

Thanks

 

[Guest]

If you don't want to use the criteria line, have you tried:
iif([Status]="pending";DateDiff("d",[DATE_RECEIVED],Now()); "Result for
False")

Thks for your reply..is it possible to include it in the calculated field
without having to add it in the query design grid

Expr1: DateDiff("d",[DATE_RECEIVED],Now())

presumably the above is a calculated field in your query design grid.

add the "pending" criteria to the criteria line of the [status] field in the
query design grid.

hth

I hv this expression in my query

Expr1: DateDiff("d",[DATE_RECEIVED],Now())

How do i put some additional condition where field [status]="pending"

I''ve tried this

Expr1: DateDiff("d",[DATE_RECEIVED],Now()) where [status]="pending"

and its give me "headache"

Thanks

 

[tina]

maybe you better explain what you're trying to accomplish with the
calculated field in the query, and the criteria - before we go any further.

hth

Thks for your reply..is it possible to include it in the calculated field
without having to add it in the query design grid

Expr1: DateDiff("d",[DATE_RECEIVED],Now())

presumably the above is a calculated field in your query design grid.

add the "pending" criteria to the criteria line of the [status] field in the
query design grid.

hth

I hv this expression in my query

Expr1: DateDiff("d",[DATE_RECEIVED],Now())

How do i put some additional condition where field [status]="pending"

I''ve tried this

Expr1: DateDiff("d",[DATE_RECEIVED],Now()) where [status]="pending"

and its give me "headache"

Thanks