DSUM Formatting

  • Thread starter Thread starter NouvalG
  • Start date Start date
N

NouvalG

Hello,

I calculated a running total in my query using the DSUM function. My
problem is that the calculation generates a text type field, rather than
numeric. I am aware of using the FORMAT function to change the format, but
this only changes its look, not the underlaying value. In other words, when
I export my data to let say excel, that field still come over as text, not
numeric....Any ideas?

Thanks,
 
In your query, use the conversion function that best fits. For example, to
convert to currency datatype, use CCur().

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I select "Standard" as datatype. The problem is that that only changes the
look not the actual underlaying value. I think the problem comes from using
a date of criteria in my Dsum function...
 
I'm not familiar with a datatype of "standard" ... I was thinking of
datatypes like "text", "number", "memo", "currency", "date/time", etc.. Are
you describing a "format", rather than the underlying type of data?

I don't understand how a "date of criteria" relates to the DSum() function.
If you are including a date/time value as a criterion, make sure you use the
proper delimiter (#).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top