I'm trying to use dlookup in a report. I think the first half is going fine, I have =DLookUp("[Grades]","[Report_Card_Grades]") and that pulls the first option from the "Report_Card_Grades" table, but I need it to pull the actual text that matches the number that is currently showing up in the field. That is in the second half, but I haven't had any trouble getting it to work. So help please!