Is there a "date-1" type function?

[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]

Bill

Is there a reason you can't use the tool you know and just TELL them you
used Access <g>?

You may (I can't tell from your description) be able to use a query to
return the records from the table(s) (I can't tell from your description)
for "yesterday's" transactions, use Day() -1 as the criterion.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tom Lake]

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"?

[YourDateField] - 1

is all you need. Replace YourDateField with the name of your
date field (what else?)

Tom Lake