Help in Writing Queries

[praveen_khm]

Hi all,

This is my first question in this forum. Hope I get help.

I have a database created. Now I am not able to write the queries. I have attached the mdb file with this. What I need is:

1. No. of resources Onsite / offshore – Project wise(Proposal Number is the Key) with planned and actual break-up. This is using the tables "Proposal Table" and "Proposal Resource".
2. Onsite to off-shore ratio. Using the "Proposal Resource Table"

Please help.

Thanks,
Praveen

 

[praveen_khm]

Any help please?

 

[namliam]

What are your problems in creating the queries? You seem to know pretty much what to do....

 

[praveen_khm]

Hey Mailman,

My problem is writing queries. I do not know how to write those queries. I tried doing it and messed it up. Can you help? Please?


Cheers,
Praveen

 

[namliam]

Yet you are able to create a union query??

How about you give it a shot and I point out where you are going wrong? I am not fixing/building your DB for you... will help you, but not build it for you...
Unless offcourse.....