Setting Unbound Report Control Source

[alr]

Hi All,

I am designing an Access 03, unbound report where the data is obtained from query results. I tried just about every permutation I could think of:

Query!queryName.fieldname, the SQL itself, etc.

Neither help nor the knowledgebase seem to have the syntax for what I want to do. For the following SQL statement or using the query name: How can I set the control source for a text box to SumOfTround and SumOfHround?

SELECT Sum(Cust.TRound) AS SumOfTRound, Sum(Cust.HRound) AS SumOfHRound FROM Cust;

Thanks for any pointers,

alr

 

[alr]

That's not the answer I wanted since I have written all the queries already... Oh well...

Thanks for looking at this I'll start a new thread if I get stuck.

alr