Hello everyone,

I have table OdabranaOprema with column Ukupno.I have made Query - OdabranaOprema Query with which I make sum of numbers column Ukupno.I would like with Command button pull the result of this query and put it in txtBrojModula,I have tried with this but something wrong,

can someone help me,

thank you in advance,

lngResult = 0

txtBrojModula.SetFocus

lngResult = Nz(DLookup("[OdabranaOprema].[Ukupno]", "[OdabranaOprema Query ]"), 0)

txtBrojModula.Value = lngResult

You have used inconsistent names for your query in the dlookup.

Hello Natasa!
Look at "DemoUkupnoA2000.mdb", (attachment),
I think it is what you need.