S
shirleym
using ACCESS 2007 AND QODBC (QB Enterprise 2010 release 7) to prepare
a report -
We are using an sp_report CheckDetail with a cleared status field
and combining with two transaction tables (check and check
expenseline tables).
QuickBooks Crashes when we run a query for greater than 12 months.
# OF RECORDS IN THE CHECK TABLE IS 20k AND CHECK DETAIL TABLE IS 25k
The query is selecting all check transactions within a date range and
printing on one line the columns for cleared status, memo(s), payee,
address, amount, acct, ectera.
We can query for ytd or a 12 month period but when we query greater
than 12 months (would like to query for 4 years worth of data) the
QODBC crashes QB software.
We set our iterator(chunk size) TO 100,000 any suggestions what to do
differently? What info do I need to post here that will help?
I am new to this and would appreciate if anyone has any suggestions.
a report -
We are using an sp_report CheckDetail with a cleared status field
and combining with two transaction tables (check and check
expenseline tables).
QuickBooks Crashes when we run a query for greater than 12 months.
# OF RECORDS IN THE CHECK TABLE IS 20k AND CHECK DETAIL TABLE IS 25k
The query is selecting all check transactions within a date range and
printing on one line the columns for cleared status, memo(s), payee,
address, amount, acct, ectera.
We can query for ytd or a 12 month period but when we query greater
than 12 months (would like to query for 4 years worth of data) the
QODBC crashes QB software.
We set our iterator(chunk size) TO 100,000 any suggestions what to do
differently? What info do I need to post here that will help?
I am new to this and would appreciate if anyone has any suggestions.