coading, subtotals

M

majed

hi to all;
Iam new to access, I have a problem in getting sub totall, my db is
bout products group and salls, :
vegetables group: code from 1000-1999
1001 tomatos
1002 potatoes
..
1999 carrots
fruts group: code from 2000-2999
2001 apple
2002 banana
..
2999 orange

meat group: code from 3000-3999
....
the number of groups is big, and also product.
the qustion is how to get the sales accourding to grous?
do I have to make a new coulmn contains a new code for sub groups?
regard
 
P

Pat Hartman

The difficulty is caused by your design. You have created one field where
there should be two. The best solution is to create one field to hold the
group and a separate field to identify the item. Once the attributes are
separated into two fields as they should be, the grouping problem will
disappear.
 
M

majed

Pat Hartman;
thank you very much for your reply, in the real DB, the product cod
consist of 8 digits, each digit means something; for example 0705100
refers to carrot; 0= food, 7 =vegetables, 05= Frisch, 1000 carrot
do I have to create 8 coeds to classify my product at differen
levels?
best regard
 
Top