Divison with an update query

[punter]

Hi,


The attached database has a query named qryInsuranceReport. I'm trying to update the column in that query named Broker Charge PCT. I'm using the update query named qryUpdateBrokerChargePCT to do this but it isn't working. The formula is

qryInsuranceReport![Broker Charge]/qryInsuranceReport![Broker Total Invoice Amt]

. It looks like it should be working but all I'm getting is either 100% or 0% so something is wrong. I have been able to use this to perform subtraction functions but I guess I'm doing something wrong with the divison part.

Any thoughts are most welcome.

Thank you

Eddie.

 

[boblarson]

Your field you are trying to store into is Long Integer which means that it will be 1 or 0 when a percentage is calculated (a percentage is a fraction of 1). Change it to something like Double.

 

[punter]

Thanks so much for the quick reply Bob. I'm looking around in the query where the field is. Where would I switch from Long Interger? I don't see that option.

Thanks

Eddie.

 

[boblarson]

In the TABLE, not the query.

 

[punter]

Outstanding. That works. Thank you very much Bob.

 

[boblarson]

My pleasure