Taking data from one table to another and then summing?

[whitelockben]

Hi all,

I have a form which is allowing input of equipmet info. To keep is simple I have tried to dumb it down as much as possible. Here is an example of the table with some data in.

Now my aim is to be able to have a table which creates a unique record for every combination of location and seg. type.

For example from this table the new table would create a new record for ZE-A ZE-B etc etc. There will always be the same number of segrigation types however there will be an undetermined number of locations.

The aim of having these new records is to have a field in each record which sums the total weight of the equipment at each location based on the segrigation type and another for the size.

An example of what I am looking for is:

Is this possible does anyone know?

Thank you,

Ben.

 

[r.harrison]

In the table design view there is an option for a Calculated Field which you can use to lookup values from the table. I'll have a play and see what I can come up with for you.

 

[r.harrison]

Been going round in circles with this one. I think I know what you are trying to achieve but doing this within the tables is not going to be easy.

My assumption is that if ZE is in Location ABCD the weight would be the same as it would be in location AD but not if it was in CD.

Am I getting this about right?

 

[whitelockben]

Each piece of equipment has its own weight and size.

The equipment is split up into types (seg. types) e.g. ZE etc etc and the equipmet is grouped as per the seg types.

What I want to do it calulate the we of the groups at each location e.g. all ZE equipment and location a, all equipment b at location ZE ... so I want a field ZE-A i.e. equipment which is in ZE and at location A.

Hope this is more clear?

 

[r.harrison]

Right, so ZE will weigh the same no matter where it is located?

 

[whitelockben]

Right, so ZE will weigh the same no matter where it is located?

No, ZE has no weight. ZE is simply a catagory of equipment it is the equipment in that catagory that has the weight.

So location a has ZE equipment 1 and 3

but at location B there is ZE equipment 1,4,7.

 

[r.harrison]

Can't seem to get my head around this one. I think it'll need to be coded into a form so that the location string can be split.

It's a pretty complex thing you're trying to do.