Search results

yea i've already tried that and have it so that it ignores the Null values, it just seems to be a refreshing error. Is there anyway to get it to keep refreshing until a certain box is equal to or greater than a value? Thanks for the idea though!

Hi all does anyone know how to stop #error coming up on forms? I have a from that looksup calculations from a number of queries and then averages them out on the top of the form. My problem is that on some occasions I will open the form and it will display #error instead of the percentage I'm...