79304545

Date: 2024-12-24 01:13:07
Score: 0.5
Natty:
Report link

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]'

Reasons:
  • Whitelisted phrase (-1): it worked
  • No code block (0.5):
  • Low reputation (1):
Posted by: John McVickar