beginners question: awarding points to a certain amount bought

[Bart Pauwels]

Hi,

I have a question regarding a query I'm trying to set up:
My sheet is a typical order-entry for my firm: I give certain bonus-points
when a certain amount is reached (sort of like a coupon when you get 1 stamp
if you for ?5.00 and 2 stamps for ?10.00)

So, I've got the order-total, but how can I "hook up" the bonus-points on to
that total?
I'm used to be working with Excell but Access offers certain benefits in
less work (except fot this)

Thanx

Bart

 

[Evi]

In your query's Design view, in the Field row of the query grid, in an empty
column type
Stamps: Int([OrderTotal]/5)

Evi

 

[Bart Pauwels]

Thanx Evi,

I wish it was that simple but it is my fault; I explained wrongfully!
Instead of whole numbers (5 here), the rating varies (from 20.00 to27.50;
from 27.51 to 40.00; from 40.01 to 55.00 and so on) it is NOT a fixed
difference...

Sorry for my mistake!

In your query's Design view, in the Field row of the query grid, in an empty
column type
Stamps: Int([OrderTotal]/5)

Evi

Hi,

I have a question regarding a query I'm trying to set up:
My sheet is a typical order-entry for my firm: I give certain bonus-points
when a certain amount is reached (sort of like a coupon when you get 1 stamp
if you for ?5.00 and 2 stamps for ?10.00)

So, I've got the order-total, but how can I "hook up" the bonus-points

on

to
that total?
I'm used to be working with Excell but Access offers certain benefits in
less work (except fot this)

Thanx

Bart

 

[Evi]

So is this like a Grades question (like grading exam papers).

If so, add a table called TblBonus with BonusID (Autonumber), MinNum (a
number field), MaxNum (a number field), Bonus (a number field).

This will have eg

MinNum 20, MaxNum 27.50, Bonus 5

(ie 5 stamps if you have between 20 and 27.50)

You have your table with its BonusPoints which might have something like
StaffID, StaffName, Score
(I'm not too sure who or what is being awarded the bonus) Score would be the
amount that that person earned.

Put the Staff table in the query grid and in a spare column put

Stamps: Grade: DLookUp("[Bonus]","TblBonus",[Score] & " Between [MinNum] AND
[MaxNum]")

Base your reports etc on this query.
Evi

Thanx Evi,

I wish it was that simple but it is my fault; I explained wrongfully!
Instead of whole numbers (5 here), the rating varies (from 20.00 to27.50;
from 27.51 to 40.00; from 40.01 to 55.00 and so on) it is NOT a fixed
difference...

Sorry for my mistake!

In your query's Design view, in the Field row of the query grid, in an empty
column type
Stamps: Int([OrderTotal]/5)

Evi

Hi,

I have a question regarding a query I'm trying to set up:
My sheet is a typical order-entry for my firm: I give certain bonus-points
when a certain amount is reached (sort of like a coupon when you get 1 stamp
if you for ?5.00 and 2 stamps for ?10.00)

So, I've got the order-total, but how can I "hook up" the bonus-points

on

to
that total?
I'm used to be working with Excell but Access offers certain benefits in
less work (except fot this)

Thanx

Bart

 

[Bart Pauwels]

You're great!

I knew something would have to do with a 'lookup' but I didn't know Access
could use this too...
The first table I had already finished but I was stuck... THanx!!!

So is this like a Grades question (like grading exam papers).

If so, add a table called TblBonus with BonusID (Autonumber), MinNum (a
number field), MaxNum (a number field), Bonus (a number field).

This will have eg

MinNum 20, MaxNum 27.50, Bonus 5

(ie 5 stamps if you have between 20 and 27.50)

You have your table with its BonusPoints which might have something like
StaffID, StaffName, Score
(I'm not too sure who or what is being awarded the bonus) Score would be the
amount that that person earned.

Put the Staff table in the query grid and in a spare column put

Stamps: Grade: DLookUp("[Bonus]","TblBonus",[Score] & " Between [MinNum] AND
[MaxNum]")

Base your reports etc on this query.
Evi

Thanx Evi,

I wish it was that simple but it is my fault; I explained wrongfully!
Instead of whole numbers (5 here), the rating varies (from 20.00 to27.50;
from 27.51 to 40.00; from 40.01 to 55.00 and so on) it is NOT a fixed
difference...

Sorry for my mistake!

In your query's Design view, in the Field row of the query grid, in an empty
column type
Stamps: Int([OrderTotal]/5)

Evi
Hi,

I have a question regarding a query I'm trying to set up:
My sheet is a typical order-entry for my firm: I give certain bonus-points
when a certain amount is reached (sort of like a coupon when you get 1
stamp
if you for ?5.00 and 2 stamps for ?10.00)

So, I've got the order-total, but how can I "hook up" the

bonus-points
on

to
that total?
I'm used to be working with Excell but Access offers certain

benefits

in