469,927 Members | 1,904 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

A2000 Auction database - need help

Hi, all,

I'm helping a friend with an auction database, and am stuck on this. Any
thoughts/suggestions would be appreciated!

Two tables - first is a table of Participants, with name, address, etc.,
including an ID number. Second table is a table of items, including
description, price, buyer #, seller #, etc. The buyer # and seller #
correspond to the ID number in the participant table. And participants can
be both buyers and sellers in the auction, or they may be only one or the
other.

What we want to do is produce a report when the participant checks out
showing items purchased, items sold, the amounts of each, and the net owed
the participant or net due from the particpant, depending on whether or not
he sold more than he purchased.

Any thoughts?

TIA

Matt
Nov 13 '05 #1
2 1285
Matt Furze wrote:
What we want to do is produce a report when the participant checks out
showing items purchased, items sold, the amounts of each, and the net owed
the participant or net due from the particpant, depending on whether or not
he sold more than he purchased.

Any thoughts?


The general line of thought here might be:

* create a query that contains all information you want in the report,
but don't do grouping, sorting or totalling here (unless the resulting
group or total is a unit piece for the report). Create a report on this
query and group/order/total accordingly.
Nov 13 '05 #2
Matt,
A table is missing. You need a third table to tie things together. In that
table is going to be:
BUYER | SELLER | ITEM, and anything else relavent to the sale. Your items
table needs to just have the attributes of the item and not things like
buyer, seller, etc.
Now for a turn to my favorite subject, data warehouse design. You have an
Item dimension, a Participant dimension, an Event dimension (bid, end of
auction, sale, payment made, etc.), a Time dimension and probably some
others that escape me at the moment (Geography?). Your measured fact(s) are
sale price, fees, number of bids . . . dunno what you need. So that's four
tables with the fact table at the center.
If it's too late to change the schema then I'd do the first option and split
my item table into two--piece one would be item information and piece two
would be sale information like I describe above.

"Matt Furze" <ma*******@cox.net> wrote in message
news:plbjd.89111$bk1.25078@fed1read05...
Hi, all,

I'm helping a friend with an auction database, and am stuck on this. Any
thoughts/suggestions would be appreciated!

Two tables - first is a table of Participants, with name, address, etc.,
including an ID number. Second table is a table of items, including
description, price, buyer #, seller #, etc. The buyer # and seller #
correspond to the ID number in the participant table. And participants
can be both buyers and sellers in the auction, or they may be only one or
the other.

What we want to do is produce a report when the participant checks out
showing items purchased, items sold, the amounts of each, and the net owed
the participant or net due from the particpant, depending on whether or
not he sold more than he purchased.

Any thoughts?

TIA

Matt

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Davef | last post: by
reply views Thread by Ravi | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.