I have a database query that is very simple with 7 columns from a linked table. The columns are for example
Customer/Invoice ref/invoice date/description/net value/vat/gross value
the problem i have is that tehre must be approximately 500,000+ rows in the query.
I want to show only those items from 2010, however when I put in a criteria such as DATE = 2010 I get the message "ODBC--Call failed [microsoft][ODBC SQL Server Driver] timeout expired (#0).
Im guessing this is due to the size of the query and the sorting necessary.
Does anyone have any idea as to how I could resolve this?
Thanks in advance...
Customer/Invoice ref/invoice date/description/net value/vat/gross value
the problem i have is that tehre must be approximately 500,000+ rows in the query.
I want to show only those items from 2010, however when I put in a criteria such as DATE = 2010 I get the message "ODBC--Call failed [microsoft][ODBC SQL Server Driver] timeout expired (#0).
Im guessing this is due to the size of the query and the sorting necessary.
Does anyone have any idea as to how I could resolve this?
Thanks in advance...