cross tab query using form criteria

[DRH192]

Hello everyone,

is it possible to specify a reference to a form field value in the where condition of a cross tab query? Access doesn't like it for some reason.

If there is no "documented" solution, does anyone know a work around, no matter how ugly. I can think of a few but they are seriously hideous and I'm sure there must be a way of overcomming this problem properly.

Many thanks

Duncan

 

[PHV]

You must define the parameter.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DRH192]

Hi, I added a param in parameters, it is of double data type. How do I know tie this into my field on my form?

 

[PHV]

The name of the paramater should be something like this:
[Forms]![name of open main form]![name of control]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DRH192]

Oh right, I think we have our wires crossed. I know you can use this method in any other query type, but when using cross tabs it doesn't work. Thanks for your help

 

[PHV]

In the SQL pane:
PARAMETERS [Forms]![name of open main form]![name of control] DateTime;
TRANSFORM ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DRH192]

Wow!! Thats great, thanks very much.