HELP! Multi field count (1 Viewer)

Please help me in counting number of appearing records show in query

Name Drinks Date purchased Count
John Milk 8/3/13 1
->Mike Beer 8/4/13 2
John Beer 8/4/13 1
Peter Wine 8/6/13 1
-> Mike Beer 8/6/13 2

Counting conditions: counting will continue if NAME and DRINKS are the same

Welcome aboard
Aggregate (totals) queries work by summarizing data. In your example if you wanted to count the drinks by name, you would eliminate the date field.
Select name, drink, count(*) as DrinkCount
From yourtable
Group by name, drink;

If you want to include the date, then you probably want to do the counting in a report.

Hello,

You can use the following query to get your result :
Good continuation