Parameter Value

R

Roy

1.) Summing the results of IIF functions into an Expression
2.) The results of (1) are numbers 1,2, ... 11
3.) Need to separately extract all outcomes, eg, "give me all 1's"
4.) Get 'Enter Parameter Value' box at this point
5.) Triple-checked spelling & [] are correct in Expression, & Show Field box
checked

Any ideas?
Thx, Roy
 
J

John Spencer MVP

For starters, POST the SQL of the query you are attempting to use.

Also post the exact message you are getting for #4.


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query? 10
Query Parameter 4
IN Clause using multi-select form parameter 6
Parameter Value 4
Crosstab query 4
Enter Parameter Value Dialog Box 2
Parameter Using InStr Function 10
Aggregate function error 2

Top