Following from my other thread, I managed to create the crosstab query Pat was suggesting, DB attached
Now, issue is the column headings and filtering
I have inserted the criteria based on the form variables, and fixed the column headings (only way I managed to make it work.. as propertyIDs) - when I chose from dropdowns, query window disappears and comes back with nothing (I know there's data to display)
Also, column headings are driven by PropertyID, which has corresponding property name in tblPropertyRegistrations, is there anyway we can link those? (this is not a biggy, ideally I want to display Property 1,2,3 (3 columns in total or maybe 4) and limit to the selection above in dropdowns)
I appreciate your time and assistance on this and million thanks
Now, issue is the column headings and filtering
I have inserted the criteria based on the form variables, and fixed the column headings (only way I managed to make it work.. as propertyIDs) - when I chose from dropdowns, query window disappears and comes back with nothing (I know there's data to display)
Also, column headings are driven by PropertyID, which has corresponding property name in tblPropertyRegistrations, is there anyway we can link those? (this is not a biggy, ideally I want to display Property 1,2,3 (3 columns in total or maybe 4) and limit to the selection above in dropdowns)
I appreciate your time and assistance on this and million thanks