Hi there,

i am hoping someone can help me.

a have a data set that of the following Headings (Project Code;Member Type; and actual(kg/m3). the project code data grows and will have duplicates(i.e. new project codes get added to the data base, there are 11 fixed member types, and the actual [kg steel/m3 concrete] are numerical values.

what i am looking to do is be able to have a drop down box which selects the project Code, which then extracts a full data list of all entries of Actual (therefore, project specific to check through each different member type and check the values/trends/results of the actual kg/m3). i am hoping to get out a dynamic chart between the info too if possible.

can someone assist me on this?? it would be greatly appreciated!

Warm Regards,
DM