Status Database Help

[Manuel Banuelos]

Hello everybody,

I am trying to create a Status Database, you know for weekly statuses of projects, I am trying to create a form that would show current and
previous weeks info (status), I have a couple of pulldown menus to show the person and another one for the project (for current week). My question is: Does anybody know how to link the current week with the previous week based in the info given this week, name and project, from the pulldown?
I have been fighting this one and asking several Access Gurus but no deliverable yet. Your help would be greatly appreciated.

Manuel Banuelos

 

[Douglas J. Steele]

It depends on how your database is structured. If you have a Date field, and
each weekly status is one week apart, you can use DateAdd to calculate the
previous week's date from the current week's date. DateAdd("w", -1,
[CurrentWeekDate])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Hello everybody,

I am trying to create a Status Database, you know for weekly statuses of
projects, I am trying to create a form that would show current and
previous weeks info (status), I have a couple of pulldown menus to show the
person and another one for the project (for current week). My question is:
Does anybody know how to link the current week with the previous week based
in the info given this week, name and project, from the pulldown?
I have been fighting this one and asking several Access Gurus but no
deliverable yet. Your help would be greatly appreciated.

Manuel Banuelos