Help need with designing this complex query


Joined
Jun 30, 2005
Messages
59
Reaction score
0
Hi every body. I am new to creating query and report. I got database and sample
report document that i want to generate the report in access each week. My big
diffuclty is how to design and create the query for this complex report so any
help would be appreciated.I posted picture of my database tables with their
reletions and sample report document below. The database is in sql server 2000
and i linked to those tables from access 2000. I be happy if some expert help
me create this complex query for this report.Thanks



http://i5.photobucket.com/albums/y180/method007/weeklyprojectdata.jpg ( report sample document)

http://i5.photobucket.com/albums/y180/method007/sqlserverreletionship4.jpg

(database tables)
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Complex Query By Form 9
Need Complex Subform Help!!! 0
Complex Form Design 3
Complex Query 3
Query Too Complex 0
Complex Form-Query 0
Too Complex Query 14
Complex query problem 1

Top