hi to all;
Iam new to access, I have a problem in getting sub totall, my db is a 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?
regards
Iam new to access, I have a problem in getting sub totall, my db is a 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?
regards