The original poster might not see this, but hopefully anyone with the same question does.
I directly referenced the alias and it worked. My query was:
SELECT SUM(amt) AS to_assets FROM ... WERE ...;
My string that I input into the control source for the text box was 'to_assets', not '=to_assets', not '=[query_name]![to_assets]'