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

 

[Upendra Agnihotram]

Dear Manuel Banuelos,

Create two different queries with equal fields for current week and previous week. Write an Union Query and Display it.

Regards,
Upendra
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


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