Paramaters in a cross-tab query...please help!!!

[Guest]

Hello

I am using Access 2002, and I was using select queries that use criteria
from a drop-down in a form - to query/filter the results. I have had to
change my queries to cross-tabs, and the queries no longer recognise the link
to the drop-down list in the form (in the criteria of the queries).

Just wondering if there is a way that you can use a field in a form (such as
a drop-down) to filter the results of a cross-tab query?

Hoping that this makes sense, and that someone can offer some assitance?

Thank you
Kind regards
AC

 

[fredg]

Hello

I am using Access 2002, and I was using select queries that use criteria
from a drop-down in a form - to query/filter the results. I have had to
change my queries to cross-tabs, and the queries no longer recognise the link
to the drop-down list in the form (in the criteria of the queries).

Just wondering if there is a way that you can use a field in a form (such as
a drop-down) to filter the results of a cross-tab query?

Hoping that this makes sense, and that someone can offer some assitance?

Thank you
Kind regards
AC

In a Crosstab query you MUST enter the parameters in the Parameter
Dialog box as well as on the criteria line.
In design view, click on Query + Parameters
Enter each parameter exactly as written on the criteria line in the
left panel (i.e. [forms]![FormName]!ControlName].
Enter the parameter datatype in the right panel.

 

[Guest]

Thanks very much Fred...your assistance is greatly appreciated
AC

Hello

I am using Access 2002, and I was using select queries that use criteria
from a drop-down in a form - to query/filter the results. I have had to
change my queries to cross-tabs, and the queries no longer recognise the link
to the drop-down list in the form (in the criteria of the queries).

Just wondering if there is a way that you can use a field in a form (such as
a drop-down) to filter the results of a cross-tab query?

Hoping that this makes sense, and that someone can offer some assitance?

Thank you
Kind regards
AC

In a Crosstab query you MUST enter the parameters in the Parameter
Dialog box as well as on the criteria line.
In design view, click on Query + Parameters
Enter each parameter exactly as written on the criteria line in the
left panel (i.e. [forms]![FormName]!ControlName].
Enter the parameter datatype in the right panel.