Convert Percentage into decimal in Microsoft Access query 1

[THWatson]

Using Access 2007

For whatever reason I am having a brain cramp here.

A electrician's database has a Materials Markup that could be anywhere from 0% to 20% (20% is the default but can be changed by the user).

In a query I want to convert that percentage to a decimal number.
e.g. change 20% to .2

In a form, the Val function does the trick, but not in a query.

What is the correct procedure?

Thanks.

Tom

 

[PHV]

What is the data type of the markup ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[THWatson]

Hi PHV
In tblMaterials the field is "number", double, format percent

Tom

 

[PHV]

Did you try the CDec function in the query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[THWatson]

The field is Markup, and assuming the value is 20%

CDec([Markup]) results in "function containing the wrong number of arguments"
CDec([Markup],2) results in "invalid use of Null"

Format([Markup],"Fixed") results in 0.20

[Markup]/100*100 results in 0.2
100*[Markup]/100 results in 0.2

I want to be sure that whatever I am using will be correct under all circumstances, as I need to calculate the total cost of Materials and then add whatever Markup the user has determined for that project.

Thanks.

Tom

 

[PHV]

And this ?
Nz([Markup],0)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[THWatson]

PHV
Indeed, Nz([Markup],0) yields 0.2

Tom

 

[PHV]

And you'll avoid the "invalid use of Null" message ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[THWatson]

THANKS!

I appreciate your help!

Tom