result of a query and to place in a variable

M

[MVP] S. Clark

DLookup(), Dcount(), DSum(), etc

dim x as [datatype]

x = Nz(DLookup("Field", "Table", "Criteria"),0)


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables. 0
Annotation Yellow Dot in BPMN seems to be centred in one place 0
Calculation Based on Dynamic Variables (What-if Scenario) 0
Drop down list control value in vba 2
Number of decimal places output 8
Visio: copy text of a master shape to User-define Cells (Variable) 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Incorporating the User Profile location into a document template path 1

Top