RE: Access 2003
I have an app that use a CheckNumber column. This check number column
is set to text because leading zeros are required on check numbers. The
table has approx. 100k rows.
Here is what the QBE window built, which runs populates a combo box for
the user to choose from:
"SELECT DISTINCT CHECKNUM FROM MyTable WHERE (((CHECKNUM)>"0")) ORDER
BY CHECKNUM DESC;"
This column is indexed as "Duplicates OK".
Is there a way to index only the rows that have a value? Would that
make it run faster?
Thanks.
*** Sent via Developersdex http://www.developersdex.com
***
