Help need with designing this complex query

T

tonyck

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)
 

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

How to get the most recent value from a table column? 0
How to calculate cumulative values of this query fields? 0
Can't create a report from my query in Access 1
Help with Search Form 2
Parameter box, complex query 6
Report Sorting Problem 1
Error checking for table fields null value constraint 0
"Query Too Complex" Errors 5

Top