Beginner

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a Query set up to calculate a rating using 2
different columns ie:-
Tbeaten Rating
0.5 120
6.75 93
10.0 80
15.0 60
Is there anyway that when the Tbeaten is over 15.0 or
more the Rating column will show 0
Any help will be appreciated
 
instead of showing the Rating field directly in the query, create a
calculated field, as

ShowRating: IIf([Tbeaten] > 15.0, 0, Rating)

if you're not familiar with the IIf() function, suggest you read up on it in
Access Help so you'll understand how it works.

hth
 
Back
Top