Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TONY - COULD YOU HELP ONE MORE TIME?

Status
Not open for further replies.
nomi1

nomi1

Programmer
Oct 17, 2006
16
US
THANK YOU SO MUCH FOR YOUR RESPONSE. UNFORTUNATELY I AM PARTICULARLY BRAIN DEAD TODAY AND CAN'T THINK BEYOUND EXCEL.

WHERE WOULD I MAKE THE CHANGE IN MY FORMULA BELOW?

IF([POST WORK QUERY.Earned Hrs]>90,"SENIOR",IF([POST WORK QUERY.Earned Hrs]>60,"JUNIOR",IF( [POST WORK QUERY.Earned Hrs]>30,"SOPHOMORE",IF( [POST WORK QUERY.Earned Hrs]>0,"FRESHMAN"))))
 
Status
Not open for further replies.

Similar threads

AyoubEddakkaoui
  • Locked
  • Helpful tip
Paradox 11: How to Fix Opening Help file (Help topics)
Replies
0
Views
265
AyoubEddakkaoui
AyoubEddakkaoui
caitlind
  • Locked
  • Question
Milan asks for more time as Moncler, Ferragamo, Bally add to packed fashion week schedule
Replies
0
Views
204
caitlind
caitlind
ebtrr
  • Locked
  • Question
Query last modify date/time of table row
Replies
1
Views
84
rum63
rum63
UA61
  • Locked
  • Question
Help getting push button to function
Replies
1
Views
208
Chucky666
Chucky666
Piper2021
  • Locked
  • Question
CALC in a query on a table to find difference between two time fields
Replies
0
Views
70
Piper2021
Piper2021

Part and Inventory Search

Sponsor

Back
Top