lookup reward value based on membership category and seat code

[blizkij]

Hi,

I am trying to set up a database that will calculate the reward offered to member for the sale of their seat. this is based on three things:

a) member category - A, K or J
b) seat category - P, G, S or B

I have a table of seat details that lists the seat category, another table that has the seat category and the reward for each member category.

For the life of me I cannot figure out how to get a query to lookup the reward by checking the seat and member category!!!

Any help much appreciated it. my Access skills have completely abandoned me over the last years.

 

[Darrylles]

Hi bliz,

Please list your table structures.


ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[blizkij]

HI Darylle,

At this stage tables are as follows:

table - member category

Category - Adult, Concession, Junior
code - A C J

table - Rewards
Member Category P G S B
Adult $19.18 $17.51 $15.68 $12.53
Concession $15.22 $13.90 $12.44 $9.94
Junior $6.02 $5.50 $4.92 $3.93

So I'm guessing i've got to do a 3 table query to do the look up by membership cat and seat type to get the rewards. But i'm struggling with exactly how to split it all out.

Sorry to be asking such a question, but it seems logic has completely deserted me!