Report from crosstab query with parameters

[mech55]

I'm having big trouble creating a report based on a crosstab query I have that asks for a start date and an ending date.

Basically what's happening is that when I create one, the boxes for the parameters start popping up in the middle of design view! and they just keep coming...

Is it even possible to create a report from crosstab with parameters?

 

[Sammy B]

Upload the db and others may be able to see what is happening. (If you do then cut out most of the records to save space)

Sam

 

[Rich]

Have you defined the Parameters in the query and do you pass them to it via an open form?

 

[mech55]

I pass them via form. I figured it out. or rather I found this website and stole the code...

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

it works now.. only thing I can't figure out is why it insists on 11 columns and headers. but that doesn't matter since only the columns that exist actually appears...