Error: Expression too complex to be calculated

[seenfresh]

I have a simple process that involves a form, query, and report. The form has list boxes pulling info from separate queries quering a data table. This form is then referenced in my main query's criteria, which is to be populated into my main report. I have a command button on my form which pulls my report in preview mode once the criteria's are passed to my main query.

I have successfully set up this process for other databases, but for some reason I get an error stating: ... too complex to be calculated.... however, the only difference in this set up than the other successful ones I have created is that the main data table has a huge amount of data spreading 50,000 rows..

I am really stuck on this one .... Any advice or suggestion would be greatly appreciated...

Thanks in advance,

 

[seenfresh]

Here is my main queries SQL statement, this may help find the problem:

SELECT [PREMIUM TABLE].SITE, [PREMIUM TABLE].GROUP, [PREMIUM TABLE].DATE_, [PREMIUM TABLE].[CAMPAIGN NAME], [PREMIUM TABLE].PLACEMENT, [PREMIUM TABLE].[IMPRESSIONS DELIVERED], [PREMIUM TABLE].[TOTAL BOOKED IMPRESSIONS], [PREMIUM TABLE].[TOTAL GROSS REVENUE], [PREMIUM TABLE].[TOTAL NET REVENUE]
FROM DATA_TABLE, [PREMIUM TABLE]
WHERE ((([PREMIUM TABLE].SITE) Like [Forms]![Premium Campaign Form]![SiteComboBox1] & "*") AND (([PREMIUM TABLE].GROUP) Like [Forms]![Premium Campaign Form]![GroupComboBox1] & "*") AND (([PREMIUM TABLE].DATE_) Between [Forms]![Premium Campaign Form]![StartDateComboBox1] And [Forms]![Premium Campaign Form]![EndDateComboBox2] & "*"));

 

[huh?]

General limits on access, see <a href="http://www.databasedev.co.uk/access_specifications.html">here</a>.

For limits on expression complexity, see <a href="http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1487750">here</a>.
The limit on nested iif statements is either 7 or 9.

For a work-around solution you can also try to shorten your sql statement by using aliases. You can also use the suggestion <a href="http://en.allexperts.com/q/Using-MS-Access-1440/access-2000-query-design-1.htm">here</a>.

Hope this helps.

 

[schielrn]

I have only used Access sparingly, but I came accross this issue once and it was when I was doing division and one of my denominators had a 0 and that was the error I received when Access tried to divide by 0. If there is any division being done I'd check the denominators.

Hope that helps.

 

[seenfresh]

Thank you for your responses... I will check em out!!!