SQL: SELECT [Copy Of Account].Owner, [Copy Of Account].Lot, Count([Copy Of Account].Owner) AS CountOfOwner, Count([Copy Of Account].Lot) AS CountOfLot
FROM [Copy Of Account]
GROUP BY [Copy Of Account].Owner, [Copy Of Account].Lot;
Owner is a number field, lot is a short text field. Both should be able to be counted easily. If you can't read that tiny picture I included it shows the [countofowner] =169 and the [countoflots]=169 each of them should be "2" (as the summary shows). Is this corruption?
TIA!