Recent content by 88videos

Works ok. Thank you for your patience.

I tried this SELECT A.sex, A.index, A.Level as lev, count(A.ID) as X, B.Y FROM MYtable A INNER JOIN (SELECT sex, index, count(ID) AS Y FROM MYtable) B ON A.sex=B.sex AND A.Index=B.Index GROUP BY A.sex, A.index, lev sex is not part of agg function I modified query to this SELECT...

CJ_London understand my goal, but I need to admit - I didn' t describe it well. And my data wasn't gooed prepared to paste it on forum --- was '\t' as separator ...Sorry for that. I can write 2 queries . 1) this works SELECT sex, index, count(ID) AS Y FROM MYtable GROUP by...

Welcome. My first post = first problem with Access. I use MS Access for a short time. I am familiar with MS SQL, but Access disappoints me. It is difficult for me to write commands, because many options does not work. My current problem. I want to aggregate and add column with aggregated...