Crosstab Crash

[briank]

I have created a crosstab query that is crashing my application 50% of the
time I run the query.
A little background on the ct query:
The Row Heading is a test field.
The Column Heading is a calculated field of text values (text & text) that
are comprised of six layers of iif conditions
The Value is a number
There is a criteria column Where: Between [Forms]![frmDateMenu2]![StartDate]
And [Forms]![frmDateMenu2]![EndDate] in which both of these dates have been
declared.
I am stumped on this and would assistance or suggestion on how to fix.

 

[briank]

I forgot to add that this crash occurs only when I run a report based on this
query - not the query itself.

 

[Jerry Whittle]

At times like this, nothing beats a good backup. I bet that the report is
corrupt.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[briank]

I have started a fresh db and imported all of the data from my original db as
well as a compacted back up. Unfortunately I am still getting a constant
crash when I try to pull up my report which is based on the cross tab query
with the defined parameters. I know this is a query forum but I am wondering
if this is now a report issue. Any thoughts?

At times like this, nothing beats a good backup. I bet that the report is
corrupt.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have created a crosstab query that is crashing my application 50% of the
time I run the query.
A little background on the ct query:
The Row Heading is a test field.
The Column Heading is a calculated field of text values (text & text) that
are comprised of six layers of iif conditions
The Value is a number
There is a criteria column Where: Between [Forms]![frmDateMenu2]![StartDate]
And [Forms]![frmDateMenu2]![EndDate] in which both of these dates have been
declared.
I am stumped on this and would assistance or suggestion on how to fix.