Solved: Create report from SQL statement

[hanta]

Hi all

The short description of my problem is, that I have to create a report out of a SQL statement. I create the SQL statement on the fly with code based on text fields and check boxes on a form and should get a report at the end. The statement is very complex, hence I can't use the built in report assistant.

Anyone with an idea how to do this?

Using Access 2007 on Windows XP

Thanks
Daniel

[OBP]

Is this Solved or not?

[hanta]

solved

but thankx

[CreganTur]

Care to share your solution, so that others with a similar problem can benefit?

[hanta]

I created a report which is linked to the query "qrSQL". Then I run the query with this code:

CurrentDb.QueryDefs("qrSQL").SQL = statement 'updates the query with my SQL statement
DoCmd.OpenQuery "qrSQL", acViewPreview 'opens the query in preview mode

Then I open the report which is linked to it and I have what I need. At lest nearly, still some things to solve like add and remove fields in the report on the fly, which gives me a little headache.

thx
Daniel