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.

Manuel Banuelos

 

[rpw]

Hi Manuel,

I tried posting a reply about 30 minutes ago and it hasn't shown yet. So if
you've already gotten a post from me, you can pretty much ignore this one.
Sorry for any duplication.

Since you didn't include table structure in your original post, I can only
offer a generalized suggestion (that is based on how I might have structured
the tables). I would have a form where the user could select the (value ID
of...) the person, the project, and the two weeks that are to be compared.
These four values could then be used as criteria in a select query. This
query could then be used as the record source for the form that displays the
comparison.

I suspect that you've included weekly status details in the project table.
That would make the above query more difficult, and it's not how I would have
structured the tables. Sorry if I'm guessing wrong though!

I'd like to suggest that you post your table structure for the gurus here to
analyze.