Using criteria on a calculated fields

[Guest]

Hello,
I have a query with a calculated field:
Print_Ron_On: [Expected_Out]-[RO_PT_DAYS]
where [Expected_Out] is also a calculated field,
Expected_Out: [LAST_ORDER_DATE]+[Supply_Good_For]
When I use criteria, >Date()
on the field, Print_Ron_On, I am asked for a parameter value for Expected_Out.
How can I apply criteria on this field with entering a parameter?
Thanks,
Glenn

 

[Guest]

Use a separate field for Expected_Out and apply the criteria there.

 

[Guest]

How do I use a seperate field for a calculated field?
Expected_Out is a calculated field, Expected_Out:
[LAST_ORDER_DATE]+[Supply_Good_For] Note, Supply_Good _For is also a
calculated field.
Thanks

Use a separate field for Expected_Out and apply the criteria there.

Hello,
I have a query with a calculated field:
Print_Ron_On: [Expected_Out]-[RO_PT_DAYS]
where [Expected_Out] is also a calculated field,
Expected_Out: [LAST_ORDER_DATE]+[Supply_Good_For]
When I use criteria, >Date()
on the field, Print_Ron_On, I am asked for a parameter value for Expected_Out.
How can I apply criteria on this field with entering a parameter?
Thanks,
Glenn

 

[Guest]

I said to apply the criteria to Expected_Out.

How do I use a seperate field for a calculated field?
Expected_Out is a calculated field, Expected_Out:
[LAST_ORDER_DATE]+[Supply_Good_For] Note, Supply_Good _For is also a
calculated field.
Thanks

Use a separate field for Expected_Out and apply the criteria there.

Hello,
I have a query with a calculated field:
Print_Ron_On: [Expected_Out]-[RO_PT_DAYS]
where [Expected_Out] is also a calculated field,
Expected_Out: [LAST_ORDER_DATE]+[Supply_Good_For]
When I use criteria, >Date()
on the field, Print_Ron_On, I am asked for a parameter value for Expected_Out.
How can I apply criteria on this field with entering a parameter?
Thanks,
Glenn