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
 
Top