Still Trying to Query Overdue Dates 1

[jchollo]

When I entered the query below - I received the error - "You may have entered an invalid identifier or typed parentheses following the null constant criteria."

The string:

Overdue: IIf([Due Date]<Date(), Int(Date()-[Due Date]) & ' days past due', '')

I do type this string for the criteria in the query design? Do I type the word Overdue with the query?

I want to figure out once a due date is past, have the results display in the Overdue field - 1 day past due, 2 days past due, etc.


tks

 

[PHV]

When in the query grid, this string is to be pasted in an empty Field cell, not a criteria one.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jchollo]

That's cool - tks PH.

 

[jchollo]

Another question - when I display in the report format, the overdue contents does not display. Only the heading Overdue. Can you display the the contents of the Overdue field in the report?

tks

 

[PHV]

Even when [Due Date] is beyond ?
What is displayed in the query data sheet view ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jchollo]

When I do the query, it displays the Overdue column along with the days overdue. But when I want to review in the report format, it just displays the Overdue column without displaying the days overdue.