Using criteria on a calculated fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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

KARL DEWEY said:
Use a separate field for Expected_Out and apply the criteria there.

mggryder said:
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
Click to expand...
Click to expand...
 
I said to apply the criteria to Expected_Out.

mggryder said:
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

KARL DEWEY said:
Use a separate field for Expected_Out and apply the criteria there.

mggryder said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top