JithuAccess
Member
- Local time
- Today, 03:53
- Joined
- Mar 3, 2020
- Messages
- 297
Guys,
I am very new to Access. I have a Table called BasicData and 5 fields FName, SName, Country, ZIP and Remarks. I have total about 500 Records In the country Field I have 3 Values USA, Mexico and Canada. I want to create a query which shows How many Records for USA, Canada and Mexico. In my Query I want show like USA : 180 Canada: 120 and Mexico: 200
Could you guys kindly direct me. I have created a query but I am not getting the result which I am looking for.
Thanks in Advance
I am very new to Access. I have a Table called BasicData and 5 fields FName, SName, Country, ZIP and Remarks. I have total about 500 Records In the country Field I have 3 Values USA, Mexico and Canada. I want to create a query which shows How many Records for USA, Canada and Mexico. In my Query I want show like USA : 180 Canada: 120 and Mexico: 200
Could you guys kindly direct me. I have created a query but I am not getting the result which I am looking for.
Thanks in Advance