Auto rating a client with collected points base a Rating table

Auto rating a client with collected points base a Rating table

Post by Simo » Sun, 17 Oct 2004 07:51:15


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
 
 
 

Auto rating a client with collected points base a Rating table

Post by Michel Wal » Tue, 19 Oct 2004 18:53:01

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

 
 
 

Auto rating a client with collected points base a Rating table

Post by U2ltb2 » Fri, 22 Oct 2004 06:49:02

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

Auto rating a client with collected points base a Rating table

Post by Michel Wal » Fri, 22 Oct 2004 19:30:15

Hi,

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

Hoping it may help,
Vanderghast, Access MVP
 
 
 

Auto rating a client with collected points base a Rating table

Post by c2ltb2 » Wed, 02 Mar 2005 06:59:03

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