Hi,

I am setting up an automated system which runs a series of crosstab
queries every month.  These crosstab queries will look as follows:

NAME     ATT
-----------------------
Mr T       145
Mr U       100
Mr V        75
Mr W       8
Mr X       98
Mr Y       78
Mr Z       65

Mt problem is if, for example, when the underlying table is created
that If Mr X count is Zero that his name shows up on the crosstab. 
Basically what I want to do is keep the list of names consistent every
month and if any 'Counts' are zero that they are still displayed. 
COnfused?????


TIA

Tim
This e-mail transmission is strictly confidential and intended solely 
for the person or organisation to who it is addressed.  It may contain 
privileged and confidential information and if you are not the 
intended recipient, you must not copy, distribute or take any action 
in reliance on it.  
If you have received this email in error, please notify us as soon as 
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however, 
Swansea NHS Trust accept no responsibility for infection caused by 
any virus received on the recipients system.