Search results

Worked like a charm. Thanks!

One more follow-up. The returned value does not appear to be recognized as a number which can be formatted in the Currency form. Is there a line of code that can be added to the end of the module, or elsewhere, that will allow me to display this number in currency format?

My apologies, Pbaldy. That worked perfectly. Thank you!

Thanks George for the advice. I must admit that I was originally trying to create calculated fields in a table, but deviated from that earlier in the design. These calculated fields are all being generated in a Query. (I hope that's not essentially the same thing). Also, I am not using...

Thanks Pbaldy, but that didn't seem to work. I'm using Access 2003 and it did not recognize the 'Minimum' function. And when I try to use Min is says I have the wrong number of arguments.

I did a couple searches on this before posting, but couldn't find anything that helps. Here is what I have (sorry it's not in table format): Purchase Price: 50,000 Max Loan on Purchase Price: 40,000 (80% of purchase price) Value: 70,000 Max Loan on Value: 42,000 (60% of Value) I need to...