0n an Access 2003 Report, I have many Records ("Material" type) in a field with many differant records each. Throuth the "Text" box control, I need to only enter the first of each types of materials. The reason that I need to do this through the "Text" box (and not a query) is I need to sum the values in another field's "Text Box and associate them with tha appropriated "Material. "Text box.
I need the SQL to go in the "Text" box.