i WOULD LIKE TO KNOW HOW I GO ABOUT TO SORT/ORGANIZE A TABLE.

  • Thread starter martina rodriguez
  • Start date
M

martina rodriguez

I am new to access and i am having some trouble organizing a table and i
understand that i need to go onto queries and so forth but i am not getting
any results, i have duplicate information and i am trying to organize and
sort my information.
 
M

mscertified

Its difficult to answer such a general question.
What data do you have and what tables are you creating?
How do you need to organize and sort the data?
Your tables should each have a primary key that uniquely identifies the
record.

-Dorian
 
M

martina rodriguez

I have a table that has the fields New Sku, Old Sku, UPC, Item, 04 Cost, O5
Cost and O6 Cost, but i am trying to organize by item, i have items (which
are plants) that are in the same family and I want the families together, not
spread out , so is their a way i can organize to put them together by family?
 
J

John Vinson

I have a table that has the fields New Sku, Old Sku, UPC, Item, 04 Cost, O5
Cost and O6 Cost, but i am trying to organize by item, i have items (which
are plants) that are in the same family and I want the families together, not
spread out , so is their a way i can organize to put them together by family?
Click to expand...

You certainly need to redesign your table structure!

For some references to basic relational design concepts, check out the
links at

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

particularly the Database Design 101 links.

In this case, you should have separate tables for Items, Costs, and
Families. I'm not certain which field ([New SKU], [Old Sku], or [UPC])
should be the Primary Key of the Items table - whichever of these
fields is *unique* and *stable* (not going to be edited in the future)
would be best. Let's say for argument that it's UPC.

In that case I'd see the following three tables:

Families
FamilyName Text Primary Key <e.g. "Compositae", "Leguminosae">

Products
UPC Text Primary Key
OldSKU
NewSKU ' don't use blanks in fieldnames
FamilyName ' link to Families

Costs
UPC ' link to Products
PriceYear Integer ' e.g. 2005, 2004
Price Currency

You would use a Form based on Products, with a combo box based on
Families; and probably a Subform based on Costs so you can see the
historical costs. It won't be hard to migrate the data from your
current non-normalized table into this one using Append queries; post
back if you need help.

John W. Vinson[MVP]
 
Top