Hi all
I would really appreciate help in trying to crack this - Im new to Access but i will do my best to explain it as clearly as possible
I have the following structure
Project > Multiple Units>Multiple Sites>Multiple Savings Types
I have created the tables to enter the records and they are working well as in the table structure below in columns and the records are entered in rows. However I would like to report all data for each project in one row as summaried in the reports table below, but every time i pick up the data from the tables to create the reports, there are multiple entries for each report for each of the types, how do i summarise all the data per project to consolidate into one row and not multiple rows?
Tables
Project ----Unit -----Site ----Type----- Saving
A----------1-------- X------- K-------- 2
A----------1-------- X-------- L-------- 3
A----------1-------- Y-------- K --------2
A----------1-------- Y-------- L--------- 1
B---------- 1------- -X-------- K --------3
B---------- 1------- X--------- L-------- 4
B---------- 1------- Y--------- K------- 2
B ----------1------- Y--------- L-------- 1
Report (that I would like)
Project----- Unit------ Site ----Type K---Type L
A----------- 1 ---------X ------2 ----------3
A -----------1 ---------Y ------2 ----------1
B -----------1 ---------X ------3 ----------4
B----------- 2--------- Y ------2 ----------1
Thanks - my db is attached for reference
Nabbale
I would really appreciate help in trying to crack this - Im new to Access but i will do my best to explain it as clearly as possible
I have the following structure
Project > Multiple Units>Multiple Sites>Multiple Savings Types
I have created the tables to enter the records and they are working well as in the table structure below in columns and the records are entered in rows. However I would like to report all data for each project in one row as summaried in the reports table below, but every time i pick up the data from the tables to create the reports, there are multiple entries for each report for each of the types, how do i summarise all the data per project to consolidate into one row and not multiple rows?
Tables
Project ----Unit -----Site ----Type----- Saving
A----------1-------- X------- K-------- 2
A----------1-------- X-------- L-------- 3
A----------1-------- Y-------- K --------2
A----------1-------- Y-------- L--------- 1
B---------- 1------- -X-------- K --------3
B---------- 1------- X--------- L-------- 4
B---------- 1------- Y--------- K------- 2
B ----------1------- Y--------- L-------- 1
Report (that I would like)
Project----- Unit------ Site ----Type K---Type L
A----------- 1 ---------X ------2 ----------3
A -----------1 ---------Y ------2 ----------1
B -----------1 ---------X ------3 ----------4
B----------- 2--------- Y ------2 ----------1
Thanks - my db is attached for reference
Nabbale
Attachments
Last edited: