Report using an SQL statment

[don2241]

Hi!
I have been looking in Help file to find out how to use a Report to view/print using an SQL statment as my source but I did not find what I was looking for.

Basically what I'm trying to do is instead of using a statment like this:
DoCmd.OpenReport "myReport", acViewPreview

I need to have "myReport" using an SQL statment instead.

Any help would be appreciated

/Martin

 

[GingerR]

Hi. I don't understand what you are talking about. If you don't want to use Docmd.OpenReport, how will you open your report? Do you mean you want your report to have a sql statement as a Record Source?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244