I have a query where I want to add number of days since last refill. How would I do this to ensure that the query knows weather there is 30 or 31 days in a month. For example, say I have a patient that on february 20th received a prescription with a 28 day supply. How could I builed a field where it will take the 28 days, add it to the 20th, and list the "due date" for the next refill?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
adding dates
- Thread starter pgh2377
- Start date
Check out DateAdd("d", 28, [FillDate])
DateAdd is a built in function in Access for "properly" adding values to dates...
=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)
Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
DateAdd is a built in function in Access for "properly" adding values to dates...
=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)
Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
- Status
Similar threads
