Status Database

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

 

[PC Datasheet]

You need to create a query that includes ProjectID and the data for the current
week. You need to build a second query that includes ProjectID and the data for
the previous week. You need to build a form with two subforms. The main form
needs to be able to identify the project. The first subform needs to be based on
the first query and the second subform needs to be based on the second subform.
With this setup, you can navigate to any project in the main form and the first
subform will show the current week's data for the project and the second subform
will show the previous week's data for the project.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com



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]

Thank You soooo much. I will give it a try.