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

"Simon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
>

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

"Michel Walsh" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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,

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

Hoping it may help,
Vanderghast, Access MVP


"Simon" <(E-Mail Removed)> wrote in message
news:4A9D43FD-A042-4854-9694-(E-Mail Removed)...
> code not work in queries, How?????
>
> "Michel Walsh" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > 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
>> >
>> >
>> >
>>
>>
>>

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

"Michel Walsh" wrote:

> Hi,
>
> There can be some ( ) that are required. What is the SQL statement?
>
> Hoping it may help,
> Vanderghast, Access MVP
>
>
> "Simon" <(E-Mail Removed)> wrote in message
> news:4A9D43FD-A042-4854-9694-(E-Mail Removed)...
> > code not work in queries, How?????
> >
> > "Michel Walsh" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > 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
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>
>