Report based on ADO recordset

[Al Newbie]

Access 2003

I have a report that at the moment has all the data from a recordset
inserted into a table and then uses the table as its recordsource (the
recordset is coming from SQL)

Is it possible to base the report directly on the recordset?

If yes how

Thanks

 

[David Lloyd]

Al:

You can use the recordset as the record source for a report in an Access
project (.adp) but not in a JET database (.mdb). The following link gives
more information on how to do this for an Access project.

http://support.microsoft.com/default.aspx?scid=kb;en-us;301987

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Access 2003

I have a report that at the moment has all the data from a recordset
inserted into a table and then uses the table as its recordsource (the
recordset is coming from SQL)

Is it possible to base the report directly on the recordset?

If yes how

Thanks