S
Sara Mellen
I posted this a week or so ago and thanks to Duane Hookom and Max Moor for
responding. Finally had time to try their solutions, but neither worked. I
think I didn't explain the problem well enough so here's another try. (My
original post has disappeared, or I'd just continue that thread.)
I'm trying to produce a report that will be used by bidders in a silent
auction. In the Detail section of this report would be a table that will
contain two columns: the first column will be a list of all the possible
bids that will be accepted for an item (ItemID). The second column will
just be a graphic box--a place for the bidder to write their bidder number.
The information for the first column should be calculated from three pieces
of information: the MinimumBid (the lowest amount that can be bid), the
Increment (the amount by which bids can be raised) and the MaximumBid (the
highest amount that can be bid on an item). So I'm trying to produce a list
of all the possible bids for each ItemID.
For example, ItemID 15 has a MinimumBid of $5, an Increment of $1, and a
MaximumBid of $10. This would result in the first column of the table
looking like this:
$5 (MinimumBid)
$6 ($1 increment is $1 added to the MinimumBid of $5)
$7
$8
$9
$10 (MaximumBid)
One thought is to generate a table with code that populates a table of
possible bids (BidLevels), with the fields BidLevelID, ItemID (linked to the
Items table) and BidLevel. It would contain all the possible prices for
each item. This table would then be the source for a subreport to be
inserted in the detail section. This is actually how this used to work, a
couple of versions of Access ago, but that code is broken and I don't know
how to fix it! I'm now using Access 2002, but the file is running as a 2000
file.
If it would be helpful to copy that code in here I will do so.
Thanks for your help. I'll respond much more quickly this time--not as many
fires to put out this week.
Sara
responding. Finally had time to try their solutions, but neither worked. I
think I didn't explain the problem well enough so here's another try. (My
original post has disappeared, or I'd just continue that thread.)
I'm trying to produce a report that will be used by bidders in a silent
auction. In the Detail section of this report would be a table that will
contain two columns: the first column will be a list of all the possible
bids that will be accepted for an item (ItemID). The second column will
just be a graphic box--a place for the bidder to write their bidder number.
The information for the first column should be calculated from three pieces
of information: the MinimumBid (the lowest amount that can be bid), the
Increment (the amount by which bids can be raised) and the MaximumBid (the
highest amount that can be bid on an item). So I'm trying to produce a list
of all the possible bids for each ItemID.
For example, ItemID 15 has a MinimumBid of $5, an Increment of $1, and a
MaximumBid of $10. This would result in the first column of the table
looking like this:
$5 (MinimumBid)
$6 ($1 increment is $1 added to the MinimumBid of $5)
$7
$8
$9
$10 (MaximumBid)
One thought is to generate a table with code that populates a table of
possible bids (BidLevels), with the fields BidLevelID, ItemID (linked to the
Items table) and BidLevel. It would contain all the possible prices for
each item. This table would then be the source for a subreport to be
inserted in the detail section. This is actually how this used to work, a
couple of versions of Access ago, but that code is broken and I don't know
how to fix it! I'm now using Access 2002, but the file is running as a 2000
file.
If it would be helpful to copy that code in here I will do so.
Thanks for your help. I'll respond much more quickly this time--not as many
fires to put out this week.
Sara