dvannoy - I saw that thread the other day, downloaded the file, and have been looking through it. I haven't found anything, yet, that would seem to allow what I'm asking, which may mean it's not possible to do with one query, which is why I asked.
Unless, you believe something in that post, like, perhaps, creating a third virtual recordset that consists of the union between a distinct query and the full database is your suggestion.
I'll have to look into that.
DrJavaJoe - The database I'm working with is one that contains data about inventory that includes a part number and various other data about the inventory. Unfortunately, there exists the possibility of each item being listed more than once dependent upon a change in one or more fields. I know, it's a nightmare and certainly not a structure I would have used, but the structure was inherited from a previous program that's still being used for part of the necessary work and changing it now would mean a lot more downtime than I can afford on this project.
So, I've been doing this operation, currently, by querying the distinct part numbers and parsing through them to collect the data that I need, I was just curious if there was a way to combine those steps into one query that would save on the resources and make the program run much faster. It looks like maybe that's not the case.