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,
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,