Hopefully an easy question

[KeithSinsa]

I have a report that I'm running off a query with date parameters (Start date, End Date). The query runs fine, but when I run the report it gives me a "too complex" message. I'm sure you are familar. Here is the kicker, it will run fine until I put the date parameter more than 13 days. Then it gives me the error. Does not make any sense. Any ideas. I use >= [Start Date] And <= [End Date] in the query. I ahve done this on several other reports. None have given me this errror message when I run the report. I kind of a novice so I hope I'm explaining this correctly. Any help would be apreciated. Thanks!

[ranman256]

If the query has a lot of joins it could say TOO COMPLICATED.

try using a form with text boxes then:
...between forms!myForm!txtStartDate and forms!myForm!txtEndDate

[KeithSinsa]

Thanks! Solved my problem. Too many joins. Created a details table.

[Rainlover]

If you have too many joins then you most likely have an incorrectly designed Database.

Just a thought.