Hello Access Forum Members,
My issue is, I have two "text" boxes on a report (text box 1 and text box 2). Text box 1 has the expression "=[data1]+[data2]+[data3]+[data4]". The results are stored/printed in text box 1 of the report.
I need to take the results in "text box 1" using less than and greater than logic (expressions) and set the results of text box 2 based on a series of "ranges". The logic for the ranges are as follows:
If text box 1 results are greater than 500, text box 2 equals a value of "GOLD";
If text box 1 results are between 400 and 499, text box 2 equals a value of "SILVER";
If text box 1 results are between 300 and 399, text box 2 equals a value of "BRONZE";
HELP PLEASE, ASAP
