DSum Function, 2 numbers from different queries, and 2 from the same.. 1

[Triacona]

I would really appreciate some help please.
I have looked into the DSum Function.
I have successfully pulled through from the query Q1d the number needed using Dlookup:
=DLookUp("Q1d","Q1D")
I tested the Dsum function by just referencing the same criteria:
=DSum("Q1d","Q1D")
That works and brings through the right number for that field.
But if I do the following:
=DSum("Q1d","Q1D" + "Q1d","Q1D")(Adding the 2 numbers together?)
It gives me an error.
I'm testing it to use on multiple queries.
I know you can add text boxes together and I have already done this, is there a more elegant way?
Thank you very much
Much appreciated
Kind regards
Triacona

 

[PWise]

how about

dsum("field1+field2",tablename,"feildx=Somevalue")

 

[Triacona]

Thank you very, very much!!
It works!!
Could you tell me if I for instance want to take a
field: OHBQ from Query called: Q1aOHBQ
and add it to a
field: Q1D from another Query called: Q1d
How would I go calling multiple table fields?
What I have at current, works: (Thank you again )

[b]=DSum("Q1d+Q1d","Q1D") [/b]

I have tried the following formula for adding two fields from two differnt Queries??:

[b]=DSum("Q1d+OHBQ","Q1D","Q1aOHBQ")[/b]

gave me an error..

Any help would be very much appreciated
Kind regards
Triacona

 

[PWise]

DSum("Q1d+Q1d","Q1D")+dsum("OHBQ ","Q1aOHBQ")

 

[Triacona]

Thank you so much!! It works!
That it is great!!
Learning all the time
Thank you again!
Kind regards
Triacona