Help need with designing this complex query

Jun 30, 2005
Reaction score
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 ( report sample document)

(database tables)


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