Dale, thanks for your input. I agree that it is not normalised, but the
reason it is in this structure is because it is a report table. I.e. it is
a table that is used as the basis of a report, and indeed it is recalculated
every time the report is run.
It is a form because this offers greater flexibility in terms of filtering
and ordering the data, and because the data for the report comes from three
quite different sources, whch can not be combined into one single report
query. There are some other reasons as well.
In this particular case, can you help me try to get an update query working
for this situation, or give me some other tips?
regards,
Ian