simple query help

[bobi123]

i would kindly ask for assitance i am a novice in access..

i have a table called business in acces and first column is: TOWN, second USERNAME, third FUL NAME ...(and some other columns)
and i would like to make a query so it will write how many people from each town are there?

example result would be:

New York 23
Chichago 56
Florida 78

 

[mahenkj2]

Make a select query, after finishing query, in design view use "Totals" and take Groupby in cities. In username of full name, apply Count.

Hope it helps.

 

[bobi123]

like this?
SELECT Count(business.town) AS counttown, Count(business.[full name]) AS [countNameLAstname], *
FROM business;

but it doesnt work

 

[pr2-eugin]

No.. something like this..

SELECT business.town, Count(business.town) AS CountTown
FROM business
GROUP BY business.town;

Hope this helps.

 

[bobi123]

omg it wooorks!!!
thank you so much!!

 

[pr2-eugin]

You are welcome..

 

[bobi123]

I would kindly ask for assistance,
I have 2 tables: "clients1", "clients2".
each table has column "userID", "name".
i need to data: which "userID" in table "Clients2" is allready in
table "clients1"?
so I would get a new "table"-list of "userID" that are allready in table "clients1",
and one table with users that are not in the table "clients1"...
help would be really appreciated... I am a beyyond beginer, i know..I didnt want to open a new topic..

 

[pr2-eugin]

Hi there.. You can use the finding the unmatched query from the Query builder.. similarly you can also find the matching query from the query builder.. simple and easy..

http://bit.ly/JIlLd5