T
Tom P
I am using ACCESS 2000 with MSDE
I have a form called 'Receipt Totals by Date Range'. The form accepts a low
and high date range then uses a continuous form to show a one-liner for each
receipt.
Part of each line are two payment amount types as RCPT_payment1 and
RCPT_payment2. The displaying of the receipt lines works flawlessly every
time.
I have a text box in the footer of the form called txtPayTotals with its
CONTROLSOURCE set to =Sum([rcpt_payment1])+Sum([rcpt_payment2]).
The problem is that for small date ranges (less than 4000 records returned)
it totals correctly every time. For wider date ranges (more than 4,000
records) it is very sporatic, sometimes totaling correctly - usually not. It
almost seems like a timing problem when there is a higher volume of records
to total.
Any thoughts ? Thanks to all!
I have a form called 'Receipt Totals by Date Range'. The form accepts a low
and high date range then uses a continuous form to show a one-liner for each
receipt.
Part of each line are two payment amount types as RCPT_payment1 and
RCPT_payment2. The displaying of the receipt lines works flawlessly every
time.
I have a text box in the footer of the form called txtPayTotals with its
CONTROLSOURCE set to =Sum([rcpt_payment1])+Sum([rcpt_payment2]).
The problem is that for small date ranges (less than 4000 records returned)
it totals correctly every time. For wider date ranges (more than 4,000
records) it is very sporatic, sometimes totaling correctly - usually not. It
almost seems like a timing problem when there is a higher volume of records
to total.
Any thoughts ? Thanks to all!