J
Jack
Hi,
Would greatly appreciate advice on whether the following query results in
memory issues (error message like "can't read memory written to 0X00000" as
well as random hanging/no response):
Query extracts top 10 records using the Top Value function based on a
calculated field sorted in the descending order using Access' standard sort
function. The calculated field contains the formula:
if(isNull(fieldB),-fieldA,fieldB-Nz(fieldA))
I used Nz as fieldA and fieldB could potentially be null fields.
Problems more frequently encountered when a form is used to preview a report
containing the results of this query.
Thanks much!
Would greatly appreciate advice on whether the following query results in
memory issues (error message like "can't read memory written to 0X00000" as
well as random hanging/no response):
Query extracts top 10 records using the Top Value function based on a
calculated field sorted in the descending order using Access' standard sort
function. The calculated field contains the formula:
if(isNull(fieldB),-fieldA,fieldB-Nz(fieldA))
I used Nz as fieldA and fieldB could potentially be null fields.
Problems more frequently encountered when a form is used to preview a report
containing the results of this query.
Thanks much!