Help with a query

[ebragg]

I need to do a query for lets say drinking water. After I enter the number
of ounces of water I drank each day into a table I want to know how much
water I drank today, and how much I drank month-to-date and how much I drank
year-to-date. Once I had enough dates to make a years worth of data how
could I do a comparison from the previous year daily, month-to-date, and
year-to-date all by just entering a single date? Not just today's date but
any date as long as I had comparison data from the previous year. Can this
be done? I cant figure out how to get this information on one query.
Can anyone help me?

Thanks.

 

[mark]

Your question sounds suspiciously like homework.
However, if it is a sincere question, try checking out
the help for the dateserial() and datevalue() functions.

Mark

 

[ebragg]

Thanks for your help but this isnt for "homework" I have asked this question
before in the context of the database I am working on but I cannot get a
clear answer so I tried to make it as simple as possible thinking that I
didnt explain myself or my problem well enough. I also want to add that I am
not by any means a programmer so any solution that comes up needs to be
pretty basic so I can understand it. You mention dateserial and datevalue,
is there a good place to find more information on these functions, because
the help section of access didnt explain it for me very well?