Condition statement, analyse data, and input an overall category

[D Dawson]

I want to add a field to an existing Building Condition Survey database which
will calculate a overall condition category (from A to D) of a building based
on the condition categories and repair cost of each building element.

Adding a new column to the building-details table is fine, but how is the
data entered in each field. i want to use the following condition statement:

For each building; If the total cost for all condition rated "C" items is =>
£5,000 the overall rating will be C, or else the rating will be B.

For additional information on the problem, please find enclosed, the
following message thread posted in microsoft.public.access.queries

Regards
Dylan
-------------------------

Your table structure is accurate.