Quick one Hopefully

[TurboDieselOne]

I have two unbound txt boxes that are meant to show the totals of a subform how do I get these unboundboxes to the value creasted in these querys

query1 should = txt1(Unbound)
SELECT DISTINCTROW tblInvoices.Nickname1, Sum(tblInvoices.Value€) AS [Sum Of Value€]
FROM tblInvoices
GROUP BY tblInvoices.Nickname1;

query2 should = txt2(Unbound)

SELECT DISTINCTROW tblInvoices.Nickname1, Sum(tblInvoices.Value£) AS [Sum Of Value£]
FROM tblInvoices
GROUP BY tblInvoices.Nickname1;

I can do it if I include them in the datasource of the mainform but I then cannot add a new record

 

[RichardJ]

You could use a DSUM function to do this, pretty straightforward just have a look in the help file.