I created a "Percentage" column and wish to update it by using the "Loan Amount". I did an update query and in the update field i keyed

=[loan amount]/sum(loan[loan amount])

but it doesn't show up the records, anyone could help me pls? thanks

=[loan amount]/sum(loan[loan amount])

Is that loan a typo?

erm sorry typo there :eek:

i typed into the update field this

=[loan amount]/sum([loan amount])

which brought nothing up. Kindly advice pls