Please give me a hand with report design :(

[kosti]

I have 3 tables and built 3 queries... Now I want to create a report with only 3 text-boxes, each of them showing a SUM of a field in the respective query.



How can i Do that??? I'm new to access so ... Thanks in advance

[apr pillai]

Use DSum() Function in the Textbox.

=DSUM("[Field Name]","Query1")

[kosti]

thank you apr pillai i'll try that, May I ask somthing else? Now I have two text boxes in my report, and i want another text box with the sum of the first two? Any idea on that?
Tanks in advance

[apr pillai]

Write the expression =[Text0]+[Text1] to get the total of both text box values.

Replace Text0, Text1 with the correct names of your text boxes.