I have developed an Access Crosstab Query that takes three fields from Table A for example with the names Name, No of hours worked, and Month.
I have the name as a row heading, No of hours worked as value and Month as the coloum heading. The query executes well. I then take another query and add the cross tab query to it and the fields of the second query are Name and each month Jan - Dec. I then bulid a report and base it on the second query.
My problem occurs when there are less than twelve months in the crosstab query. Beacause the second query and report have twelve field names representing the twelve months and the crosstab only has info for five months so it means 7 field names are going to be invalid.
Does anyone have a suggestion about how to fix this or a different approach I can take?
Start Free Trial
