Making a link with a between (1 Viewer)

[jca]

I have two tables, one with a list of clients with there annual consommation of a product and another one with the categories of clients per range of consommation.

So, if a client take 2000 liters per year, he's a client type AB. Cause in the other table, all client between the range of 1500 and 2500 are type AB.

How can I make a link between these two table so i can make a new table with all the infos I need, client no., consommation and his type.

Thanks

 

[Rich]

If you already have the information then you don't need another table to store the same thing, use a query to extract the information.