Parameter Query Problems

[Greg]

I am trying to set a perameter for my query but keep getting an error: The
Microsoft Jet database engine does not reconize '[Enter Customer Code]' as a
valid field name or expression. The only difference from other queries with
the same parameter in my database is that this query is a crosstab.

How do I fix this problem?

Thanks,
Greg

[Tom van Stiphout]

On Thu, 16 Oct 2003 01:56:50 GMT, "Greg" <gk******@itlan.net> wrote:

I just added a parameter to a crosstab query in the Northwind sample
database. Works fine.
You probably have a typo.

-Tom.

I am trying to set a perameter for my query but keep getting an error: The
Microsoft Jet database engine does not reconize '[Enter Customer Code]' as a
valid field name or expression. The only difference from other queries with
the same parameter in my database is that this query is a crosstab.

How do I fix this problem?

Thanks,
Greg

[pjac]

Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<nf********************************@4ax.com>. ..

On Thu, 16 Oct 2003 01:56:50 GMT, "Greg" <gk******@itlan.net> wrote:

I am trying to set a perameter for my query but keep getting an error: The
Microsoft Jet database engine does not reconize '[Enter Customer Code]' as a
valid field name or expression. The only difference from other queries with
the same parameter in my database is that this query is a crosstab.

How do I fix this problem?

Thanks,
Greg

You cannot add a parameter to a crosstab query. Solution: Use the
Crosstab query as a source of your inquiry, then add your parameter.

[Greg]

I have tried to create the parameter in another query that pulls from the
crosstab but ran into the same problem. Do I need to do the create a query
1st and use that query for the crosstab to run from?

Thanks for the help!!

Greg

"Greg" <gk******@itlan.net> wrote in message
news:CV*****************@nwrdny03.gnilink.net...

I am trying to set a perameter for my query but keep getting an error: The
Microsoft Jet database engine does not reconize '[Enter Customer Code]' as a valid field name or expression. The only difference from other queries with the same parameter in my database is that this query is a crosstab.

How do I fix this problem?

Thanks,
Greg

[Tom van Stiphout]

On 16 Oct 2003 04:34:49 -0700, pj**@erols.com (pjac) wrote:

I disagree. I created this in the Northwind sample application:
TRANSFORM Sum(CCur([Order
Details].[UnitPrice]*[Quantity]*(1-[Discount])/100)*100) AS
ProductAmount
SELECT Products.ProductName, Orders.CustomerID, Year([OrderDate]) AS
OrderYear
FROM Products INNER JOIN (Orders INNER JOIN [Order Details] ON
Orders.OrderID = [Order Details].OrderID) ON Products.ProductID =
[Order Details].ProductID
WHERE (((Orders.CustomerID)=[Give Product ID]) AND ((Orders.OrderDate)
Between #1/1/1995# And #12/31/1995#))
GROUP BY Products.ProductName, Orders.CustomerID, Year([OrderDate])
PIVOT "Qtr " & DatePart("q",[OrderDate],1,0) In ("Qtr 1","Qtr 2","Qtr
3","Qtr 4");

-Tom.

Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<nf********************************@4ax.com>. ..

On Thu, 16 Oct 2003 01:56:50 GMT, "Greg" <gk******@itlan.net> wrote:

>I am trying to set a perameter for my query but keep getting an error: The
>Microsoft Jet database engine does not reconize '[Enter Customer Code]' as a
>valid field name or expression. The only difference from other queries with
>the same parameter in my database is that this query is a crosstab.
>
>How do I fix this problem?
>
>Thanks,
>Greg
>

You cannot add a parameter to a crosstab query. Solution: Use the
Crosstab query as a source of your inquiry, then add your parameter.