Looping Data in a table to capture changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that has different price points. I would like to to loop
through the table and extract the count of items and the sum of the items
price at each price point.

my question is that i can program each price point seperately but is there a
way to have this happen programatically at each change in price point?

Thank you in advance
 
Backing up one step, it sounds like your table is not correctly designed.
You need two tables:
TblItem
ItemID
ItemDescription
etc

TblPricePoint
PricePointID
ItemID
PricePointDate
PricePoint

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Thank you for the Imput.

I can do that but I still do not see how I get the desired resuilts from
that as well.

My goal is to gather the number of sales and the dollar value of those sales
by price point without filtering by pricepoint

Is that possible? And i am just not seeing it.
 
Thank you again for the imput. again I am trying to make things more
difficult than needed.

Created a table with price points and was able to join exsisting table group
and sum as needed on price points and total sales at each price point
 
Your definition of the problem is clearer that in your first post! Besides
the two previously recommended tables, you need two additional tables for a
total of four tables:
TblSale
SaleID
SaleDate
etc

TblSaleDetail
SaleDetailID
SaleID
ItemID
Quantity
PriceEach

Your Sales form/subform needs to be set up so that when you enter the items
in the sale, you enter the current PricePoint for PriceEach. After doing
that, you can get the results you want from TblSaleDetail.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top