Hi Rabbit,

Thank you for your reply. I have tried to outerjoin the crosstab with the list of members. I joined the names in the member list with the attended.value in the corsstab but it says

"Cannot join on Memo, OLE or Hyperlink Object ([qryQyarterDrill 2005].[Value]=[tblMemberList.[NUMBER/NAME])."

Any suggestions?

Cheers

Dan

Hi,

Hard to explain but I have a query that sorts the type of training attended "Drill" and by which members during a certain year. I then have crosstab query that counts the amount of "Drills" the members have attended in each quarter. The members that have attended are fed from a multi combobox from the table.

When the crosstab query runs it only shows the members that attended the "drill"....

Hi,

I have a table where I record attendance. I created a query to show how many times someone has attended in each quarter. I am wanting to be able to specify which year as atm it is showing all years. The SQL is below. From this I have a report where it displays the data and have conditional formatted it so that if they have not attended more than 4 times in one quarter the "cell" turns red - the only problem is is that...