Decimal Points

[jspe377522]

Hi there,

I have a requirement for a simple database that calculates a cost based on less than a penny (uk currency) per item. It is based on a meter reading system.

Basicly the database has 5 fields as follows:

1. Cost - e.g £00.007
2. last reading - eg 100
3. current reading - eg 200
4. difference between 2 and 3 - eg 100
5. total invoice value (field4 x field1 = value) - eg 70p

I want field 1 and 5 to be based on 2 decimal points. so that i can put .07p (1p would be shown as 1.00p) in field 1. and in field 5 it calulates the value and puts £00.70

I have a sample of my work so far if needed. I am sure it is really easy. I am just puzzled because I think filemaker works with £ not p. i think.

Any help much appreciated.

Cheers
James

 

[lebisol]

layout mode:
-select the filed(s) in question
-Format--> Number (as decimal: and the rest is intutive....how many ,. and Symbols $ leading ...etc)

all the best!