Hi Chaps,
Me again......
I have resolved few steps in my Crosstab query issue, now can filter for 2 fields ! But I need more.... As usual....
I have attached my sample DB, and this is what I need to do but have no idea how to
Table tblSalaryScale contains salary details by department/position/hotel and year (this list will grow by hotel count), created crosstab query "tblSalaryScale_Crosstab" is working as intended, lists all years,departments, positions as rows, and all the hotel data in columns - so far so good
Form1, I have number of Combo Boxes, working fine ones are Department and Year but I need/want to filter 5 particular hotels (could be 2,3 or 4 also) - ComboBoxes already in the form ,data for the data already filtered ie year, department and position - this is where I am failing and I don't want to display set selection of hotels, I want user to select which hotels to compare
Any ideas folks? I am really desperate.....
Me again......
I have resolved few steps in my Crosstab query issue, now can filter for 2 fields ! But I need more.... As usual....
I have attached my sample DB, and this is what I need to do but have no idea how to
Table tblSalaryScale contains salary details by department/position/hotel and year (this list will grow by hotel count), created crosstab query "tblSalaryScale_Crosstab" is working as intended, lists all years,departments, positions as rows, and all the hotel data in columns - so far so good
Form1, I have number of Combo Boxes, working fine ones are Department and Year but I need/want to filter 5 particular hotels (could be 2,3 or 4 also) - ComboBoxes already in the form ,data for the data already filtered ie year, department and position - this is where I am failing and I don't want to display set selection of hotels, I want user to select which hotels to compare
Any ideas folks? I am really desperate.....