scaling of decimal value resulted in data truncation

A

Audrey1980

Hi I am getting the following error:

'scaling of decimal value resulted in data truncation'

This is my query:
PARAMETERS [Forms]![Main Menu]![Store] Text ( 255 ), [Forms]![Main
Menu]![Year] Short, [Forms]![Main Menu]![Week] Short;
SELECT dbo_Despatch_data_branch_summary.Year,
dbo_Despatch_data_branch_summary.Branch,
(([Extd_REV]-[Extd_WCEV])/[Extd_REV]) AS [Input Margin],
Avg((([Extd_REV]-[Extd_WCEV])/[Extd_REV])) AS [Input Margin Avg],
dbo_Despatch_data_branch_summary.PG
FROM dbo_Despatch_data_branch_summary
WHERE (((dbo_Despatch_data_branch_summary.Year)="2009") AND
((dbo_Despatch_data_branch_summary.Branch)="573") AND
((dbo_Despatch_data_branch_summary.Week)="14"))
GROUP BY dbo_Despatch_data_branch_summary.Year,
dbo_Despatch_data_branch_summary.Branch,
dbo_Despatch_data_branch_summary.Extd_REV,
dbo_Despatch_data_branch_summary.Extd_WCEV,
dbo_Despatch_data_branch_summary.PG;

It is Avg((([Extd_REV]-[Extd_WCEV])/[Extd_REV])) AS [Input Margin Avg]
that's causing a problem:

Extd_REV = Number with 18 points of precision
Extd_WCEV = Number with 18 points of precision
Any ideas? Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Audrey1980 - Group by 5
Query not picking up form values 1
SCALING OF DECIMAL VALUE RESULTED IN DATA TRUNCATION 3
error scaling of decimal value resulted in truncation 0
Scaling decimal value data truncation error 0
Scaling results in data truncation 2
Scaling of decimal value resulted in data truncation 1
Scaling of decimal value resulted in data truncation 1

Top