Invalid scale for decimal data type

[exRP12Nuke]

Hello,

I am building an Access program, and when I try to sort one of my final select queries using the drop down menu, it tells me "Invalid scale for decimal data type."

I have looked around Access websites for some help, but most of what I was able to find was about setting the data type in a table, this is a select query so I am not sure what is wrong.

Any help would be greatly appreciated.

Thanks!

-Brett

 

[SkipVought]

forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

forum705

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[exRP12Nuke]

Thanks Skip, I thought that I posted in the Access forum, I will repost there.