Calculated Controls and Queries

K

Kelly

I have created a calculated control to caculate the date I enter for 90 days
after the date I entered. My problem is that I need to query for these
calculated dates, but since they are in an unbound box I am unable to query
for it. Is there someway I can query for the dates or to create a bound box.
Please let me know if anyone has any suggestions or ideas. I will
appreciate any help I can get!
Thanks
 
R

Rick B

In an unbound box? Is this a form or a query?

What do you mean you need to query for them?

If you enter a date of january 30 and the calculated date is May 2, then
what? Are you saying you now want to find records where that date is in a
particular range?

You'll have to give us more details.
 
K

KARL DEWEY

You can use the unbound control as criteria in a query.
[Forms]![YourForm]![YourUnboundControl]
 
S

Sprinks

Kelly,

If you were able to calculate it on a form, you can also calculate it in a
query. The syntax in the Query By Example view is:

MyCalculatedField: MyExpression, for example:

ExtdPrice:[Qty]*[UnitPrice]

Hope that helps.
Sprinks

Hope that helps.
Sprinks
 
Top