title: Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
body: <p>I have a table, call it TBL. It has two columns,call them A and B. Now in the query I require one column as A and other column should be a comma seprated list of all B's which are against A in TBL. 
  e.g. TBL is like this</p>
  
  <p>1   Alpha</p>
  
  <p>2   Beta</p>
  
  <p>1   Gamma</p>
  
  <p>1   Delta</p>
  
  <p>Result of query should be </p>
  
  <p>1   Alpha,Gamma,Delta</p>
  
  <p>2   Beta</p>
  
  <p>This type of thing is very easy to do with cursors in stored procedure. But I am not able to do it through MS Access, because apparently it does not support stored procedures. 
  Is there a way to run stored procedure in MS access? or is there a way through SQL to run this type of query</p>