I wrote a function called 'Yesterday' that's quite simple: TODAY()
-1. I use this to print a list of yesterday's shipments. Of course, the
obvious problem for a five-day-a-week company like ours is that, when you
run it on Monday, you always return 0 records. Has someone written a
function that returns TODAY()-3 when it's Monday, TODAY()-2 on Sunday, and
TODAY()-1 every other day?

Kenneth E. Urban
Manager, Information Systems & Technology
Major Industries, Inc.
7120 Stewart Avenue
Wausau, WI 54401
(715) 842-4616 voice
kurban@...