Hi All,

I'm a spreadsheet guy getting into db's for a job requirement.



So, here's my problem.

I'm building a database that needs to generate dailey reports that include today's data and yesterday's data and then computes some statistics. So for instance, I'll have a cell in the 3/10/09 report that contains the day's receipts and another that contains the previous day's receipts. My question is how do I get a cell that automatically loads the receipts from the day before, let's call it "Date-1"?

Also, since many values in my fields will not change everyday, can I make my input form enter default values in certain fields that it gets from the day before when I open the form yet still allows me to change the value as required?

Thanks in advance for your help.

Regards,
Bill Beausoleil