A
Alex
Hi Everybody,
We have a table with the following fields:
ItemNum LotNum and ProdDate
123 527 05/15/2009
123 527 05/15/2009
123 527 05/13/2009
123 528 05/12/2009
124 529 05/15/2009
124 529 05/15/2009
…
We’d need to get records for all items that have the same LotNum and
different Date. In our sample above it would be the following group:
123 527 05/15/2009
123 527 05/15/2009
123 527 05/13/2009
Could anybody advise what query would be for it to get all those groups of
items?
Thanks
We have a table with the following fields:
ItemNum LotNum and ProdDate
123 527 05/15/2009
123 527 05/15/2009
123 527 05/13/2009
123 528 05/12/2009
124 529 05/15/2009
124 529 05/15/2009
…
We’d need to get records for all items that have the same LotNum and
different Date. In our sample above it would be the following group:
123 527 05/15/2009
123 527 05/15/2009
123 527 05/13/2009
Could anybody advise what query would be for it to get all those groups of
items?
Thanks