Alex Rivera | Logout

Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess

Asked 2008-10-23T15:40:24.583
10

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

1 Alpha

2 Beta

1 Gamma

1 Delta

Result of query should be

1 Alpha,Gamma,Delta

2 Beta

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

sql ms-access stored-procedures ms-office
Edit
Report

2 Answers

3

I believe you can create VBA functions and use them in your access queries. That might help you.

answered 2008-10-23T16:32:48.783
2

There is not a way that I know of to run stored procedures in an Access database. However, Access can execute stored procedures if it is being used against a SQL backend. If you can not split the UI to Access and data to SQL, then your best bet will probably be to code a VBA module to give you the output you need.

answered 2008-10-23T15:47:45.957

Your Answer