Search results

Thanks to crosmill, Pat and raskew - I will book next week off work and work through all your solutions until it works!!! Thanks

Thanks for the reply - I am trying to create another field in the same query which will name the max. field from the previous fields which all contain numbers eg. sat sun mon tues Best Day 3 5 2 1 sun ps. I am not using days, just the best scenario I can show. Thanks

Hi, I am trying to return the name of a field if it meets my criteria eg. Field A = 25 Field B = 35 Field C = 30 If I want to return the field with the max. number I would like Field D to say "Field B" Hope I've explained well enough - Thanks

Thanks very much for the replies - both are great.

I have a form and subforms on a 3 page tab. There are calculated controls on the form and data inputted to the form is also read by various queries in the background. When I change certain values and then save changes and come out of form or even just click on subform area, I get a 'Write...