how to format the dsum value?

[polis]

Hello guys i have a query that runs a dsum calculation



RunningTotal: DSum("[AverageHourlyRate]*[ManHours]","LaborCostingQuery"), and i dont have options in the fields property to format the value (i.e Euro)

Thanks in advance

[June7]

What is your question - what is the issue - error message, wrong results, nothing happens? This calc will provide a sum for ALL records in the table. Is that what you want?

[polis]

Yes i have the values that i need, but i want to set the format property of those values to and in property box the are no options available.

[alansidman]

When I open a query in design view and right click on a field and select properties, I have the option in the format line, I can select Euro. Is this not available to you?

Alan

[polis]

Thanks alansidman
It is available for every other field except the one i am calculating the dsum

[alansidman]

I cannot replicate your issue. Perhaps it is time for you to post a copy of your database to this forum. Be sure to sanitize it for confidential information and only put a sample of your data (not the full data). Be sure to run a compact and repair to reduce the size before posting. Once we see it, we can analyze what is happening and give you some answers.

Alan

[June7]

No options are available because the value returned by domain aggregate function is a string. The query doesn't know this is a number. Use Val function to convert the value to a number then the options will be available or do the formatting in a form or report textbox.
Val(DSum("[AverageHourlyRate]*[ManHours]","LaborCostingQuery"))

[polis]

aha .... thanks alansidman and june7 for your answers, now is working perfect