Incorrect numeric values returned from expression

  • Thread starter Thread starter Sally
  • Start date Start date
S

Sally

Apologies if this has already been answered!

I have a table that has a field called AMOUNT, which is an
amount in pence. I've created a query with an expression
to display the amount in pounds & pence. Sounds simple
enough:

Payment: ([AMOUNT]/100)

However, the new field 'Payment' merely rounds the amount
down to the nearest number of whole pounds. If I try
putting it as decimal, it justs displays 2 zeros instead
of the number of pence.

Example:
DATE Payment AMOUNT
20030410 318 31862

Any ideas on how I can get the correct data displayed
would be gratefully received.

Many thanks
 
Check the FieldSize of the Payment field. It is probably Long. It should be
Double or single if you want to have decimal portion. You can also use a field
type of currency (max 4 decimal figures).
 
Back
Top