Date() functiom

[Carl Johnman]

I am currently using in a query:
Warning: Switch([RecievedDate]=Date()+ 1,"Warning: The
deadline is one day past due!")
and continued to 3 days but I ran into a problem: How can
I sum up all dates 4 or more days late in one summary
statement?

Thanks for any help,
Carl

 

[Wayne Morgan]

See if this will work.

Switch(......, [RecievedDate]>=Date()+ 4,"Warning: The deadline is four or
more days past due!")