Crosstab query requiring parameter limits

[John Asheld]

I have an injury database containing table of factors. I
have combined the necessary fields from the table with a
selection query and then run a crosstab query to do
statistical analysis. This is fed into a report. All
works well. I am trying to add a parameter limitation so
that I can restrict the time period (dates) that are
included. When I attempt to do this in the crosstab query
I am losing the column head data although the parameter
limitation appears to work. I am unsure how to correct
this. Any help would be appreciated.

 

[Tom Wickerath]

Hi John,

You didn't indicate whether you had explicitly defined the parameter by adding it to the
Query Parameters dialog box. If you did add it, make sure that you add it exactly as it
occurs in the criteria row.

http://support.microsoft.com/?id=209778

Tom
___________________________________


I have an injury database containing table of factors. I
have combined the necessary fields from the table with a
selection query and then run a crosstab query to do
statistical analysis. This is fed into a report. All
works well. I am trying to add a parameter limitation so
that I can restrict the time period (dates) that are
included. When I attempt to do this in the crosstab query
I am losing the column head data although the parameter
limitation appears to work. I am unsure how to correct
this. Any help would be appreciated.