Crosstab Query - Parameters

[jferna31]

When I tried to parameter a crosstab Query by a selected query which the first one is based on (Date/Time field), I received the following error message: The Microsoft Jet database engine does not recognize <name> as a valid field name or expression.
Anybody can help me!

 

[MattS]

You need to set the column headings property in the crosstab query.

 

[jferna31]

Sorry I'm trying to do that but I have some problems!
Can you give me an example, Please?

 

[dcx693]

When running a crosstab parameter query you must define the parameters (unlike with a select or action query). Have you done that? In the Query menu go to Parameters... Enter the parameter name exactly as you entered it in the criteria line and specify the data type.

 

[jferna31]

I 've already done that, but I received the following error: Invalid bracketing of name [Forms]![Calendar Ingresos y Egresos]![BeginningDate]. (Error 3126)!

 

[dcx693]

Just to be thorough here: you're not including that final period in your Parameter definition right?
[Forms]![Calendar Ingresos y Egresos]![BeginningDate].

Because including the period would produce that error message.

 

[jferna31]

Yes, I've included that in the parameter box!
In the criteria space of a DATE field, I put this: Forms![Calendar Ingresos y Egresos]![BeginningDate] And [Forms]![Calendar Ingresos y Egresos]![EndingDate]
And in the parameter box I tried to put both.

 

[dcx693]

Well, take out the period, and put the two parameters on separate lines. Does that work now?

 

[jferna31]

Funcionó Muchas Gracias!

Yeah! Thanks a lot, it worked!

 

[dcx693]

De nada.