By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,462 Members | 2,308 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,462 IT Pros & Developers. It's quick & easy.

Parameter Query Problems

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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


Nov 12 '05 #2

P: n/a
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.
Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

P: n/a
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.


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.