Hi All,
I have a parameter-query and when you execute it and 'fill in' the parameter it takes a very very long time when the results are displayed on the screen.
Now, that seems normal if you have a very large table, but when I enter the parameter in the criteriafield manually it displays the results immediately. Very strange. I have indexed the field so that cannot be the problem.
Does someone know what I do wrong?
I have a parameter-query and when you execute it and 'fill in' the parameter it takes a very very long time when the results are displayed on the screen.
Now, that seems normal if you have a very large table, but when I enter the parameter in the criteriafield manually it displays the results immediately. Very strange. I have indexed the field so that cannot be the problem.
Does someone know what I do wrong?