Crosstab Query - Invalid Procedure Call message

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hello Stuart.

Stuart said:
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.
Click to expand...

This is probably a vba problem. Open a module in design view and check
Tools, References... and fix all "MISSING:" entries.
 
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


Wolfgang Kais said:
Hello Stuart.

Stuart said:
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.
Click to expand...

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