Parameter?

[FreddyBotz]

Upon entering the following formula in a query:IIF(ROUND([Col1]/3,2)*3=[Col1],[Col1],ROUND([Col1]/3,2)*3) a message pops up indicating that I must enter a parameter value. Can someone please explain this to me?

Thank You

FB

 

[CindyK]

Freddy - ROUND isn't a built in function with Access (at least not with Access 97). I use it quite a bit in my databases, but have a function in a global module. I'm guessing it might be because you don't have that module in the database where you're using the round function??

Cindy K.

 

[FreddyBotz]

I haven't the slightest idea Cindy. Access 2000. How would I determine if I have the module or not?

Thanks

FB

 

[tlbroadbent]

FB,

Do you have a column in your table named col1? My guess is that the column name is something different. Replace col1 with the name of the column you want to use in the calculation. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[CindyK]

Freddy - Terry's suggestion is the way to go - I was doing a brain fade. The fact that you're getting a parameter error is more likely due to the bracketed item not being found. If you didn't have the round function, the error message you would receive would probably state something like "undefined function".

Just for general knowledge though (and lol, to help make up for my faux pas!!) - if you change the COL1 to match your field name and no longer get an error message, then the round function has been added to your database. It could be in a couple different places - but if you go to a code window and do an Edit, Find you could search for the word "Round" in the entire database. It would bring up whatever module it's stored in. (In the alternative, it's possible that Access 2000 includes Round as a built in function, but I don't think so. I don't have Access 2000 right at hand to check it.)

 

[tlbroadbent]

Access 2000 has a Round function. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin