hi, can anyone teel me how to use the date range function.
specifically, i create an aging report for receivables and i have tried
the following:
if {Receivables.ActivityDate} in Aged0To30Days Then
{Receivables.PriceCost}
else
0
as suggested by online help.  the database is an access 2.0 table and
the field is date/time formatted.  the error detected in the formula
editor is "a string is required here" and the cursor is placed in front
of "Aged0To30Days".  any help or suggestion is greatly appreciated.
thanks.