By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,711 Members | 1,323 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,711 IT Pros & Developers. It's quick & easy.

Dsum Function In Access

P: 1
The following VBA code gives me am error message, dont know what the syntax issue is, can anyone help

totEmdFlt = DSum("[NUMBER OF UNITS]", "EMD LOCO CUSTOMERS", "[CUSTOMER CODE] = " & cboCustID)

thanks
May 24 '07 #1
Share this Question
Share on Google+
1 Reply

JConsulting
Expert 100+
P: 603
The following VBA code gives me am error message, dont know what the syntax issue is, can anyone help

totEmdFlt = DSum("[NUMBER OF UNITS]", "EMD LOCO CUSTOMERS", "[CUSTOMER CODE] = " & cboCustID)

thanks
Expand|Select|Wrap|Line Numbers
  1. totEmdFlt = DSum("[NUMBER OF UNITS]", "[EMD LOCO CUSTOMERS]", "[CUSTOMER CODE] = " & cboCustID.column(0))
  2.  
  3.  
assumes column(0) is the customer code equivalent
J
May 24 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.