Auto rating a client with collected points base a Rating table

[Simon]

Hi,
I have access tables collected points from my client and want to auto auto
rate them base on a rating table, but rating field I can manual over write
it if I want to. How to set the code?
2 table are: ClientInfo table and Rating table
ClientInfo table with 3 fields:
ClientID Point Rating
1 10 A
2 05 A
3 11 B
4 50 C <----- over writed from F
5 32 D

Rating table with 3 fields: MinRate and MaxRate from 1 to 100 may change
value from times, field SetRate values from A to Z
SetRate MinRate MaxRate
A 01 10
B 11 20
C 21 30
D 31 35
E 36 40
F 41 50

Thanks in advance.
Simon

 

[Michel Walsh]

Hi,


SELECT ClientID, POIN, SetRate
FROM Clients INNER JOIN Rates
ON Clients.Rating BETWEEN Rates.MinRate AND Rates.MaxRate



Hoping it may help,
Vanderghast, Access MVP

 

[Simon]

code not work in queries, How?????

Hi,


SELECT ClientID, POIN, SetRate
FROM Clients INNER JOIN Rates
ON Clients.Rating BETWEEN Rates.MinRate AND Rates.MaxRate



Hoping it may help,
Vanderghast, Access MVP

 

[Michel Walsh]

Hi,

There can be some ( ) that are required. What is the SQL statement?

Hoping it may help,
Vanderghast, Access MVP

 

[simon]

SELECT ClientID, POIN, SetRate
FROM Clients INNER JOIN Rates