Thank you for looking at my question,
I have a query in MS Access 2013 that I know contains more than one contract against item
Select Item, Contract, StartDate, EndDate, Value
Where EndDate > Now();
To find the multiple contracts I did a count of the instances of each item no ...
Select Item, Count of Item
Group By qryContracts_Current.Item;
Where Count of Item>1;
... and then re-queried the original query vs the multiples query
Select qryContracts_Multiple.Item, qryContracts_Current.*
FROM qryContracts_Current_Multiple INNER JOIN qryContracts_Current ON qryContracts_Current_Multiple.Item = qryContracts_Current.Item;
It strikes me that, if I were a little more experienced/sophisticated I should be able to achieve the same result with one query or at most two.
Could somebody show me how to do this more efficiently please?