Help needed creating new database

[sabrish72]

Hi there,
It been a long time.
I need help here since I've stop using access for more than 2 years and it starts rusty.


Can anybody help me, nothing fancy, it just gathering data from multiple table.

I have 3 table.
Table 1 : Project Info
Content : Project No., Project Description, Start Date, Finish Date and Forecast Completion

Table 2 : Project 1
Content : Project No., Week Ending, Plan Progress, Variance Plan, Actual Progress, Variance Actual

Table 2 : Project 2
Content : Project No., Week Ending, Plan Progress, Variance Plan, Actual Progress, Variance Actual



What I need is just a report having
Project No., Project Description, Plan Progress, Variance Plan, Actual Progress, Variance Actual.
Data from both project 1 and 2 in this report but data from a date which i select.


Please help and thanks for reading

[June7]

You show Table 1 and Table 2 (twice). Should one of those be Table 3?

Should be one table for project weekly data with another field for project ID, which already seems to be there.

Then building report with filter criteria should be simple.

[sabrish72]

You show Table 1 and Table 2 (twice). Should one of those be Table 3?

Should be one table for project weekly data with another field for project ID, which already seems to be there.

Then building report with filter criteria should be simple.

True it should be table 3, my wrong

[sabrish72]

Can anybody help create simple one as sample that I can use?
I did create a file but can't upload due to the size of file

[June7]

Don't know your business rules and don't want to build for you.

What exactly do you not understand about building db? You say you already have tables so you know how to build tables. Then build a report. Use the design wizards (although I don't like to) for a shortcut. Access Help has guidelines. Lots of tutorials on web. Get a basic book.