Search results

I have a number of tables (i think 3 in total) with vaious data in them, mainly to do with attendance. I have them all linked up joined on an ID field 9which is unique to each person) so that i can gather data from all 3 tables. The problem is when i try to use a formula with values from one...

i have separate cross tabs for each group, which is a group of ID numbers. In these cross tabs i am working out a summary of sales for each year, with years going from 2006 to 2009. My problems comes when there is no data for a certain year for an id number. It compacts the cross tab columns...