DSUM Formatting

[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,

 

[Jeff Boyce]

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

 

[NouvalG]

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...

 

[Jeff Boyce]

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