One of my tables is surgical operations - a resident participates in each operation but has one of three roles - surgeon, first assistant, or teaching assistant. I use a cross-tab query to give each resident a summary of their experience to date - for each operation, how many they have done as surgeon, first assist, and teaching assistant.
Problem is, if they have only done cases as surgeon or first assistant, if I have a third field in the report for teaching assistant, it will generate an error because the Query for that resident doesn't have that 3rd column. Same possibility with the 'first assistant' column. You see, I want to do this with the same query and report, and just vary the criteria to select out cases for that resident only (I tie it all together on an unbound form and I use a combo box and a public variable to pick the resident, then a function populates the cross-tab query's criteria that picks for the resident).
If this makes sense to anyone, I would love some advice.
Problem is, if they have only done cases as surgeon or first assistant, if I have a third field in the report for teaching assistant, it will generate an error because the Query for that resident doesn't have that 3rd column. Same possibility with the 'first assistant' column. You see, I want to do this with the same query and report, and just vary the criteria to select out cases for that resident only (I tie it all together on an unbound form and I use a combo box and a public variable to pick the resident, then a function populates the cross-tab query's criteria that picks for the resident).
If this makes sense to anyone, I would love some advice.
