query or maybe report problem (1 Viewer)

nerak99

New member
Local time
Today, 10:58
Joined
Feb 2, 2010
Messages
5
I have an example question from an old exam. You make a database where users bid for house designs and if they are successful in their bid they knock out the lowest bidder for that design of house.

When the bidding is over there are 57 successful bids and 57 plots. The successful bids are accessed easy enough by searching on a "bid currently successful field".

There is a one to one match between successful design bids and plots available for that design.

So a row from the 57 successful bids query would be

date, value of bid, successful, ID, design.
20/1/2010 $218000 Yes joe.bloggs DT3

A Row from the plots table will have
Plot Id, Design e.g.
TW1001, DT3

Once the bids are over I want to generate a report or report on an on-screen form where the successful bids and plots are joined up to allocate plots to bids.
The successful bids query is easily made to be in the same order as the plots table.

Whenever I try to generate a query to do this I end up with either plots allocated lots of times to bidders or bidders allocated lots of times to plots.

Any ideas
 

Users who are viewing this thread

Top Bottom