Query Column A type and Column B type = cost

[Mark909]

I wonder if anyone can give me some pointers in the right direction.

Ill trying to write a query which will form the basis of a report

Basically its cost of engineering works and how much it would cost to build
a certain type of chamber in the ground.

I have a table containg information about different chambers. Each chamber
has a Project ID. There are a number of chambers which reference to the same
Project IDs.

The costs of these will differ according to the Project ID.

There is a column called "Chamber Type". Each cell holds the record of each
of the three possible chamber types.

There is another Column called "Surface Type". Each cells holds the record
of each of the three possible surface types.

Therefore I need to build a query that says:::

If this "Project ID" is used how much will it cost to build a certain
"Chamber Type" with a certain "Surface Type"

These costs would then be updated in the query. The query would then be used
to produce a Report showing the costs.

Thanks for any help. I hope my explanation is not too confusing!

 

[Clifford Bass]

Hi Mark,

Are you saying you have three tables? Four tables? Is there a
relation between the surface and the chamber? Or the surface and the
project? How about posting the relevant tables and columns?

Clifford Bass

 

[Mark909]

I have just one table at the moment called chambers which contains
Project_ID, Chamber_Type and Surface_Type columns.

I was wondering how to create a query something along the lines of:

If "Chamber_Type" = Type of chamber and "Surface Type" = Type of surface
then a new column called "Cost" will = specifed costs

 

[Clifford Bass]

Hi Mark,

You cannot store the costs in a query. And I would not recommend that
you use a formula in your query to determine the cost. Big pain to change
when the costs change. Better to store them in a table somewhere. How about
just adding a cost column to your table?

Clifford Bass