printing recordset

[mané_uk]

Hi all,

I run a store procedure in my SQL backend which return information to my
access front end through a recordset. How can I "transform" this recordset
into a report? For what I've been reading it seems that you can't use a
recordset as a recordsource!? would it be possible to create an unbound
report and populate it through a loop? (Sorry if the questions sounds
ridiculous but I'm only starting on SQL/Access!!)

Many thanks for your help
Mané

 

[Duane Hookom]

Have you tried creating a pass-through query that executes your stored
procedure? You could then use the p-t as the record source for your report.