Grouping and adding values of grouped data. Problem with writing a query

[fulbin88]

I have a csv file, I made a table from it in Access:
pastebin.com/pSVXsg5r
in the new table I would like to create four groups and assign them values.

• Group 1 EXP
• Group 2 KOM
• Group 3 PCK
• Group 4 TRP(new group name):HRL, L_F, LEA, PTP, SCH, TPE, UWA, VER.

I would like to display vdata1 vdata2 and HOURS for each user divided into groups. (sum of vdata1, sum of vdata2, sum of hours for each group EXP, KOM, PCK, TRP)






Here is my Database in Access, please hints or study materials
http://www.mediafire.com/file/dcska0...Table.rar/file


I have a csv file, I made a table from it in Access:
pastebin.com/pSVXsg5r
in the new table I would like to create four groups and assign them values.

• Group 1 EXP
• Group 2 KOM
• Group 3 PCK
• Group 4 TRP(new group name):HRL, L_F, LEA, PTP, SCH, TPE, UWA, VER.
• 

I would like to display vdata1 vdata2 and HOURS for each user divided into groups. (sum of vdata1, sum of vdata2, sum of hours for each group EXP, KOM, PCK, TRP)

Here is my Database in Access, please hints or study materials
http://www.mediafire.com/file/dcska0...Table.rar/file


https://stackoverflow.com/questions/...riting-a-query

[orange]

I have approved your 3 posts and merged them since they are similar/related.
You should be aware that many readers will not open offsite files/links.
You correctly showed us that you have cross-posted similar question on stackoverflow.
You have some responses there.
Welcome to the forum.

I recommend you describe what you are trying to achieve in simple terms in plain English.
You could also attach your csv file with a description of the data and your requirements.