I have noticed an odd problem and I'm wondering if anyone can shed
light on it. Perhaps it is a bug, or maybe it is a characteristic of
the QuickSort feature that I wasn't aware of.
I have a query that returns 53 records. However, when I run the
QuickSort, the number of records in the datasheet changes to 50
records. If I use Remove Filter/Sort, it changes back to 53. (FYI,
this query is based on three related tables, and there are two
parameters/criteria in the design.)
So far, I can see that the three records being filtered out are
duplicate lines, so that must have something to do with it. I did try
specifying the sort in the query design window instead, and that works
just fine, returning the 53 records.
I provide training and support to Access newbies, and I know that this
issue will come up for them. Can anyone advise as to what is happening
and why?
Thanks.