report from sql coding....

I

ismail

could u please help me...how can i make report...
from a sql statments..ie. i have query in coding....

thanks in advance...
 
O

Ofer

Create a query from the sql that you have, then use the report wizard to
create a report based on this query.
Now that you have a report, if you want to change the sql of the report
every time you open the report, on the on open event of the report you can
write the code

Me.Recordsource = SQL
 
O

Ofer

Ok, so copy this code, open a new query, change the query view to SQL, and
paste the code, save it and you'll have a query.
 
Top