Help on DB With Updating Dates

slkasulke

Registered User.
Local time
Today, 14:54
Joined
May 31, 2012
Messages
27
Hi,

I am creating a database that tracks current projects for my team at work.

Some projects are only due once (e.g., mailed brochures due on 1/1/14) and some are due at scheduled intervals (e.g., status report due monthly, quarterly, etc.)

Ultimately, I'm hoping that my end result will allow us to click on a form and look at what everybody has due that day, in the next 7 days, and so forth.

I am having a hard time picturing how to get this to work. Does anybody have any ideas?

Thanks!
 
Generally when I want to do this sort of reporting, I build a popup form with two unbound date fields on it. Then I build a query/report/form/whatever that points to those two fields for its Criteria (>= the left one, <= the right one, etc... remember to account for 'time' if these are not pure date fields).

You can even set the Default for those two fields if necessary - for example MOST of our reporting in one database is monthly, so I have the fields come up populated with the first and last days of last month.
 
Generally when I want to do this sort of reporting, I build a popup form with two unbound date fields on it. Then I build a query/report/form/whatever that points to those two fields for its Criteria (>= the left one, <= the right one, etc... remember to account for 'time' if these are not pure date fields).

You can even set the Default for those two fields if necessary - for example MOST of our reporting in one database is monthly, so I have the fields come up populated with the first and last days of last month.

I guess I should have phrased my question more tactfully. How would I accomplish the addition of due date fields with ever-changing dates? It's fairly simple with dates that don't change, but if something is due on the fifth of every month and another is due quarterly, how would I accomplish that?
 

Users who are viewing this thread

Back
Top Bottom