Re: Query for an Auction

Hi Worldbadger,

Think is that I would have my doubts about using an access application
with a front end application that can have potentially unlimited users.

Access can only handle, at the very most (and I am open to correction
if anybody has other opinions) 20 users.

Good luck

Nick

worldbadger wrote:
Hello,

I have an problem. I made a small auction using .asp and access2000
where the user bids and a table holds the following information;

table - bids

ID
auction_id - integer
usernumber - text
lot_no - integer
bid - currency
bidtime(mm/dd/yy hh:mm:ss) - date/time

There is a separate table for the auction lots

ID
auction_id - integer
lot_no - integer
description - text
minbid - currency
vendor - text

What I want is a query where all the following happens(selected from
specific auctionnumber):

1. All lots are selected whether there is a bid or not.
2. If no bids then "n/s" is put in bid column
3. Highest bid only is placed in bid column for multiple bids
4. For identical high bids, the earliest one is selected and a asterix
(*) is put to the right of the highest bid indicating tie bids

Here is what I have so far:

SELECT bids.auction_id, bids.lot_no, Max(bids.bid) AS MaxOfbid
FROM bids
GROUP BY bids.auction_id, bids.lot_no
HAVING (((bids.auction_id)=[Enter Auction No]));

The problem is that this does not give me all lots, does not put "n/s"
in unsold lots, and does not check for tie bids and place an asterix
(*) beside the tie bid amount.

Any help would be appreciated.

worldbadger

.

Relevant Pages

  • Re: Duhhhhh!
    ... First, although a single above-market bid can indeed end an auction, ... miss some bids due to the % rise in the amount bid for the offering. ... current price is above what bidders feel they need to pay. ... The market price is set by the highest bidder. ...
    (uk.rec.waterways)
  • Re: Duhhhhh!
    ... First, although a single above-market bid can indeed end an auction, ... auctions wouldn't produce the desired market data is ... miss some bids due to the % rise in the amount bid for the offering. ... current price is above what bidders feel they need to pay. ...
    (uk.rec.waterways)
  • Re: Question
    ... We've seen it here a lot, even when the auction description is very clear. ... If someone wins it again, doesn't pay, I'll neg them and move on. ... Search 'parts phone' and you will and dozens, any time, most with bids. ... that that phone powers up, since I could not verify it makes and recieves ...
    (alt.marketing.online.ebay)
  • Re: Cancelling an auction with a bid
    ... selling a similar product and want to see how your auction fares. ... Don't expect bids in the last 8 hours, ... price you are comfortable selling the product for. ...
    (alt.marketing.online.ebay)
  • Re: General discussion: the state of the art in slam bidding
    ... Everyone loves a good slam auction, ... reference to cue-bidding style and integrating cue bids with other conventions. ... Do you include controls already shown via cue-bids? ...
    (rec.games.bridge)