Posted by Stephen Auerbach on December 16, 2003 at 12:55:27:
In Reply to: Re: DB Express posted by Barbara Brazil on December 16, 2003 at 09:25:28:
A ha. Now you see my problem. "value of the date specified as a constant."
Look at Quickbooks for example. With that software you can select all records in the current month, in the current quarter, in the current year, etc.
I need a report/view that uses the system date, not a constant.
A report that always prints last month's invoices no matter what month last month was. It's a computer; it "knows" today's date. It's not a Qantel after all.