Crosstab Query - Invalid Procedure Call message

[Guest]

Hi,

I have created a crosstab query to show orders by product by month, using
product name as my row heading and order date as my product heading and sum
of quantity of ordered as the value.

The problem I am having is I have attempted to format the order date to
mmm-yy so my column headings read jan-05, feb-05... etc. The field reads -

Month:format([Date Ordered],"mmm-yy")

However every time I run the query I am getting a warning message - !
Invalid Procedure Call

I have created cross tab queries using this technique in the past but I just
can not see what I am doing wrong in this instance.

Can anybody help?

Thanks in advance

 

[Wolfgang Kais]

Hello Stuart.

Hi,

I have created a crosstab query to show orders by product by month,
using product name as my row heading and order date as my product
heading and sum of quantity of ordered as the value.

The problem I am having is I have attempted to format the order date
to mmm-yy so my column headings read jan-05, feb-05... etc.
The field reads -

Month:format([Date Ordered],"mmm-yy")

However every time I run the query I am getting a warning message
-! Invalid Procedure Call

I have created cross tab queries using this technique in the past but
I just can not see what I am doing wrong in this instance.

This is probably a vba problem. Open a module in design view and check
Tools, References... and fix all "MISSING:" entries.

 

[Duane Hookom]

If your references are ok, you might want to make sure you don't have any
records with no [Date Ordered].

--
Duane Hookom
MS Access MVP

Hello Stuart.

Hi,

I have created a crosstab query to show orders by product by month,
using product name as my row heading and order date as my product
heading and sum of quantity of ordered as the value.

The problem I am having is I have attempted to format the order date
to mmm-yy so my column headings read jan-05, feb-05... etc.
The field reads -

Month:format([Date Ordered],"mmm-yy")

However every time I run the query I am getting a warning message
-! Invalid Procedure Call

I have created cross tab queries using this technique in the past but
I just can not see what I am doing wrong in this instance.

This is probably a vba problem. Open a module in design view and check
Tools, References... and fix all "MISSING:" entries.