Example:I have a table with 3 fields: Name,Book,NumBooks
Each Name can have more than one book. I want to count the number of books each name has and put it in the NumBooks field.
ie: Update 'NumBooks' to equal count 'Book' for 'Name' = 'Name'. Setting up a Query Update Name to Count(Book)...