Something i've been using more and more as I learn my way through the tangled web of databases are stored procedures.
I'm used to using SQL Server which has lots of powerful T-SQL functions at my disposal.
I'm now working on a small MS-Access database for a small scale project i've bene workig on.
Is it possible to create a procedure/query in MS-Access that allows me to variables.
In my particular case I wish to pass through the name of the table I wish to query.
Any examples you could point me to would be greatly appreciated