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

time dsum and #

100+
P: 222
Dear all


What is the difference between
Expand|Select|Wrap|Line Numbers
  1. =nz(DSum("Invoiceamount","invoices","[customerid]=" & [CustomerID] & "and" & "[credit]= " & True  &  " and [invoicetime]<#" & [receipttime] & "#"),0)
  2.  
and
Expand|Select|Wrap|Line Numbers
  1. =nz(DSum("Invoiceamount","invoices","[customerid]=" & [CustomerID] & "and" & "[credit]= " & True  &  " and [invoicetime]<" & [receipttime] & ""),0)
  2.  
both function returned the same value but I need the accurate one. I am afraid in future to get different values.

What does the # really do ?

receipttime data type is date (long time).

Any comments would be appreciated.


THANK YOU IN ADVANCE


REGARDS
Nov 30 '08 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
The pound sign tells Access that receipttime is defined as a DateTime DataType.

Linq ;0)>
Nov 30 '08 #2

nico5038
Expert 2.5K+
P: 3,072
To get all info on date/time you should checkout:
The Access Web - Date/Time: Index of Articles

Nic;o)
Nov 30 '08 #3

Post your reply

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