Auto rating a client with collected points base a Rating table

  • Thread starter Thread starter Simon
  • Start date Start date
S

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
 
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
 
code not work in queries, How?????

Michel Walsh said:
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
Click to expand...
 
Hi,

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

Hoping it may help,
Vanderghast, Access MVP
 
Back
Top