Question on Parameters

[Novaember]

Hello
I have a query that returns results based on customer name and year.
In the dataset I have many rows like customerID, ProductType, ProductDescription.

After I get my first dataset for customer/year I then want to find all records where ProductDescription = Apple and count that as 1.

Right now I have something similar to this: AppleCount: IIF([ProductDescription]=[Apple],1,0)

When this runs I get a pop-up box asking for the Parameter for Apple.

The ProductDescription field has a dropdown where the user can choose Apple, Orange, Banana which is stored in tblProdDescription.

Do I need to put in my expression the original table where the dropdown is located? I'm not sure how to stop the Parameter pop-up.
Thanks!

 

[Kryst51]

In your expression take the apple out of brackets and put it in quotes instead like: "apple" , the brackets indicate a field name and that is why you are getting the error.

At least I think... But it is a step to try.

 

[Novaember]

Newp that didn't work. When I take out the brackets and save then run the query it asks me for the parameter again. Then when I go back into builder the brackets are around apple again!
>.< weird
Maybe I need quotes around it?

 

[Kryst51]

Did you put the quotes around it like I suggested?

 

[Novaember]

Did you put the quotes around it like I suggested?

WHOOPS! Missed the quotes part!
Thanks that fixed it perfectly! /dance

 

[Kryst51]

I am so glad!!! And I love the fact that it made you dance.