Grouped by not showing correct no recs

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

I've group a customer table by the following fields:
Active, OnHold, State, PriceCode, Program
and ran a make table query based on this grouping.

Then I've added fields to this table for a price increase amount based on
the groups.

I want to run an update query to update the price in the customer table but
when I join he two tables I only get 406 records rather than 2116.

I make the join on each of the fields in the table I made.

I thought that since the original groupings came from the customer table
that I should be able to get all of the records in the customer table.

Hope this is clear enough.

Thanks.
 
I don't know all of the details of your tables and query, however, I would
check to see if the group table accounts for all the possible groupings of
Active, OnHold, State, PriceCode, and Program in the Customers table.

It would be helpful to see the SQL of your update query, as well as the
fields from both your group table as well as the customers table.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I've group a customer table by the following fields:
Active, OnHold, State, PriceCode, Program
and ran a make table query based on this grouping.

Then I've added fields to this table for a price increase amount based on
the groups.

I want to run an update query to update the price in the customer table but
when I join he two tables I only get 406 records rather than 2116.

I make the join on each of the fields in the table I made.

I thought that since the original groupings came from the customer table
that I should be able to get all of the records in the customer table.

Hope this is clear enough.

Thanks.
 
"Price in the Customer table" does not sound right to me. I'd say your
table structure is not corect. Show us /all/ the fields in the table
(names only, not types or lengths), and which field(s) are the primary
key.

HTH,
TC
 
Back
Top