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]

Re: Parameter Query Problems

On Thu, 16 Oct 2003 01:56:50 GMT, "Greg" <gknapper@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.
[color=blue]
>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
>[/color]

[pjac]

Re: Parameter Query Problems

Tom van Stiphout <tom7744@no.spa m.cox.net> wrote in message news:<nf6sovgt0 118ralvqooct08c 14uub5c5ot@4ax. com>...[color=blue]
> On Thu, 16 Oct 2003 01:56:50 GMT, "Greg" <gknapper@itlan .net> wrote:[color=green]
>>
> >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
> >[/color][/color]

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]

Re: Parameter Query Problems

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" <gknapper@itlan .net> wrote in message
news:CVmjb.1933 8$0I6.192@nwrdn y03.gnilink.net ...[color=blue]
> 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[/color]
a[color=blue]
> valid field name or expression. The only difference from other queries[/color]
with[color=blue]
> the same parameter in my database is that this query is a crosstab.
>
> How do I fix this problem?
>
> Thanks,
> Greg
>
>[/color]

[Tom van Stiphout]

Re: Parameter Query Problems

On 16 Oct 2003 04:34:49 -0700, pjac@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.Produc tName, Orders.Customer ID, Year([OrderDate]) AS
OrderYear
FROM Products INNER JOIN (Orders INNER JOIN [Order Details] ON
Orders.OrderID = [Order Details].OrderID) ON Products.Produc tID =
[Order Details].ProductID
WHERE (((Orders.Custo merID)=[Give Product ID]) AND ((Orders.OrderD ate)
Between #1/1/1995# And #12/31/1995#))
GROUP BY Products.Produc tName, Orders.Customer ID, Year([OrderDate])
PIVOT "Qtr " & DatePart("q",[OrderDate],1,0) In ("Qtr 1","Qtr 2","Qtr
3","Qtr 4");

-Tom.

[color=blue]
>Tom van Stiphout <tom7744@no.spa m.cox.net> wrote in message news:<nf6sovgt0 118ralvqooct08c 14uub5c5ot@4ax. com>...[color=green]
>> On Thu, 16 Oct 2003 01:56:50 GMT, "Greg" <gknapper@itlan .net> wrote:[color=darkred]
>>>
>> >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
>> >[/color][/color]
>
>You cannot add a parameter to a crosstab query. Solution: Use the
>Crosstab query as a source of your inquiry, then add your parameter.[/color]