Max price vs individual price

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working in Access 97. I have the following data in a table:

Entry Each Price Day Price
1 10 35
1 10 35
1 15 40
1 15 40
2 10 35
2 15 40

The prices for the tickets for Entry #1 would be:

$50 if based on the each price or $40(for all tickets...I want to compare
the each price vs the max day price) if based on the day price.

The prices for the tickets for Entry #2 would be:

$25 if based on the each price or $40(for all tickets...I want to compare
the each prices vs the max day price) if based on the day price.

With the above in mind I want to come up with a query which will determine
the best pricing structure for the entry and ouput the following...

Entry Qty. Description Day Price
1 1 day 40
2 1 each 10
2 1 each 15

Any help would be greatly appreciated.
 
It won't happen in just one query, but through a series of queries, and
possibly by appending the data to a common destination table, you can
manipulate the data into any form or fashion.

Looks to me like you need to do a grouping by each category, then compare
the results.
 
Back
Top