>Sele traintime as TotTrain Where Not EMpty(traintime)

First thought: "Why aren't i using that?"

then i realized that i want other group totals on the rest of the fields in the group. That where clause would exclude the other records.

I'm working on a nightmarishly complex string to val summation and string reconstituion, and i think it works, but it's ugly.