result of a query and to place in a variable

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top