Calculating the proper price

From: SHIPP (SHIPP_at_discussions.microsoft.com)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 06:21:03 -0800

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. 

-- 
M. Shipp

Relevant Pages

  • Re: Straddles for Tuesday, Feb 21
    ... 15 above either the bid or ask price and enter that as the limit price ... my reasonable question of your entry technique possibly altering.. ...
    (misc.invest.stocks)
  • Re: Searching specific record using VLOOKUP function.
    ... you have passed into the LOOKUP function. ... My table is not sorted and it has multiple entries for a search criteria. ... there can be multiple entries for an item but only one entry will have ... Price. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Searching specific record using VLOOKUP function.
    ... value for the last IT1 in the list: ... My table is not sorted and it has multiple entries for a search criteria. ... there can be multiple entries for an item but only one entry will have ... Price. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Calculating the proper price
    ... Create a summation query, grouped by Entry number, that shows the ... sum of the Each price, and the max of the Day price. ... Maximum Day price is larger than the sum of Each price. ... Create a third query, based on the original table, where the Entry ...
    (microsoft.public.access.queries)
  • Re: Microsoft Access, Double Data Entry and breaking the Normalization rule
    ... cost and price of an item when you sell the item. ... I have to store the 2nd entry so the ... This works very well for validation purposes, ...
    (comp.databases.ms-access)