the right side of the = sign that you show doesn't make sense, given the rest of the data.
but the wizard-generated 'find duplicates' query can do most of this. IDK if that's what you need or not, but give it a try if haven't already. In your example, a query like that would produce something like this:
Code:
date item numberofdups
2/1 1456 2
2/1 4566 2
if you need something more sophisticated, such as a comparison of all piece of data on each order that could've been duplicated, you may need to use recordsets.