UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Query problem    
 
   
Natasa
post Mar 29 2006, 03:18 AM
Post #1

UtterAccess Addict
Posts: 168
From: Croatia
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
Go to the top of the page
 
+
Peter46
post Mar 29 2006, 04:19 AM
Post #2

UtterAccess VIP
Posts: 7,438
From: Oadby Leics, UK
You have used inconsistent names for your query in the dlookup.
Go to the top of the page
 
+
MStef
post Mar 29 2006, 04:52 AM
Post #3

UtterAccess VIP
Posts: 1,097
From: Zagreb - Croatia
Hello Natasa!
Look at "DemoUkupnoA2000.mdb", (attachment),
I think it is what you need.
Attached File(s)
Attached File  DemoUkupnoA2000.zip ( 11.08K ) Number of downloads: 1
 
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 07:01 PM