Inserting yesterdays data automatically?

[wbeau]

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

 

[Jeff Boyce]

Already responded to in another newsgroup...

Regards

Jeff Boyce
Microsoft Office/Access MVP