calculation

[Carlos]

HI

I m trying to accomplish the following

Im using Filemaker pro 5, I've created a DB in order to keep up with all the jobs we have. Each job is allocated a job No. everything is working fine except I need a calculation to complete the DB. I have 5 feilds, each feild I need to give a seperate value eg.

[john.daly]

I can't quite work out what you are trying to do in the first part but the second question seems fairly straight foraward. You need four fields;

Time spent (number)

Activate (text with a pop up list Yes/No)

Hourly rate (global number assuming your rate is the same for all jobs)

Charge (calculation)

where the calculation is:

If ( Activate = "Yes", Time spent * Hourly Rate, "")

Hope that helps.

[Carlos]

Thanks

I'll give that a try

carlos