Problem query with calculated number and a parameter

  • Thread starter Thread starter joshbell
  • Start date Start date
J

joshbell

Hello,

I am trying to achieve something relatively simple but it's not
working for me. Any help would be greatly appreciated.

In a calculated field, Aged Date, I would like to set up a parameter so
the user can specify how many days, greater or equal value, to display.
For example:

Calculated field - Aged Days: Date()-[tblClaim]![datClaimLetterDate]
Parameter - >=[Days greater or equal to display]

When I run the query, it does not display the numbers greater than what
is typed in, it treats the field as text. How should I format this to
display my desired results.

Thank you in advance for your help!
 
For example:

Calculated field - Aged Days: Date()-[tblClaim]![datClaimLetterDate]
Parameter - >=[Days greater or equal to display]

When I run the query, it does not display the numbers greater than what
is typed in, it treats the field as text. How should I format this to
display my desired results.
Click to expand...

Try converting it explicitly into a number - I think the syntax is:
=Value([Days greater or equal to display])
Click to expand...
 
Back
Top