Query Error Message

[Guest]

I need help in identifying why I am getting this message. I have a query for
a Report where my defined field returns the message that says:
**The Microsoft Jet database engine does not recognize -
'Forms![Level-Top-Reports]!DivID!' as a valid field name or expression.**

My query has the following field in one line:
SpcCode: IIf(DMax("[GrpNo]","Group","[DivID]=" &
([Forms]![Level-Top-Reports]![DivID]))>"A" Or
DMax("[GrpNo]","Group","[DivID]=" &
([Forms]![Level-Top-Reports]![DivID]))>"1",[GrpNo] & "." & [ccnumber] & "." &
[RoomOrder],[ccnumber] & "." & [RoomOrder])

The reason why I need help is because I have exactly the same field in other
reports and they run without any problems.

 

[Guest]

Is the form Level-Top-Reports open?

It's need to run for the query to recognize it

 

[Guest]

Yes, it is open.

Is the form Level-Top-Reports open?

It's need to run for the query to recognize it

--
Good Luck
BS"D

I need help in identifying why I am getting this message. I have a query for
a Report where my defined field returns the message that says:
**The Microsoft Jet database engine does not recognize -
'Forms![Level-Top-Reports]!DivID!' as a valid field name or expression.**

My query has the following field in one line:
SpcCode: IIf(DMax("[GrpNo]","Group","[DivID]=" &
([Forms]![Level-Top-Reports]![DivID]))>"A" Or
DMax("[GrpNo]","Group","[DivID]=" &
([Forms]![Level-Top-Reports]![DivID]))>"1",[GrpNo] & "." & [ccnumber] & "." &
[RoomOrder],[ccnumber] & "." & [RoomOrder])

The reason why I need help is because I have exactly the same field in other
reports and they run without any problems.

 

[John Spencer]

Is the report's query a cross-tab query. If so, you must declare the
parameter in the query.

First thing, with a crosstab query you MUST declare your parameters and
if any other queries are used in the crosstab their parameters must also
be declared.

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2

 

[Guest]

John,

You are correct. I declared the [Forms]![Level-Top-Reports]![DivID]
parameter as you described below and worked like a charm. The query was not a
crosstab query but has a crosstab query as one of the sources. I noticed that
if I deleted the crosstab query as one of the sources for two fields, the
query had no problems displaying the results. The expression I had was not
referencing to any values of the crosstab query.

Is there any simple explanation of why this needs to happen with crosstab
queries?

Thank you.

Martin