Access 2000 Parameters in Crystal 8.5

[Hillary]

I have 3 queries in Access that work off 1 parameter. When I attempt to run a Crystal Report off these queries I get the message, "Too few parameters. Expected 1". In Access, if I remove the parameters and enter the (parametered) information in design view, I can see the information in Crystal.

Is it possible to have a parameter set up in an Access query that is used in Cystal? How???

Thanks

Hillary

 

[Gramm]

It is possible to create a parameterized query in an Access Project.

 

[synapsevampire]

Perhaps you can share what this parameter is doing?

I see this done in the Access Consolidated Balance Sheet example in CR 9, so it's likely possible in CR 8.5

I don't use Access, but it seems that you could just build a query and use it without an embedded parameter (turn on the views display in the data explorer) and pass a Crystal parameter to it.

-k