Hi all,
I am stuck with a problem, I have a form called frmUsage, at run time the form is in a Datasheet view.
I need to have a calculation of some of the materials not all..
For example in my form this is what I would have:
Materials Usage
Corn 1234
Corn 5673
Salt 15
Rice 980
Corn 1230
How can I have the total for Corn alone? Let me remind you that the form is a continouos form and at run time it is a datasheet view...
Basically in my Total fields for Corn will be: 8137
Total Salt: 15
Total Rice: 980
How can I do this??
Need help asap.... Any help is appreciated... I hope that I explained my problem good.. Thanx in advance..
I am stuck with a problem, I have a form called frmUsage, at run time the form is in a Datasheet view.
I need to have a calculation of some of the materials not all..
For example in my form this is what I would have:
Materials Usage
Corn 1234
Corn 5673
Salt 15
Rice 980
Corn 1230
How can I have the total for Corn alone? Let me remind you that the form is a continouos form and at run time it is a datasheet view...
Basically in my Total fields for Corn will be: 8137
Total Salt: 15
Total Rice: 980
How can I do this??
Need help asap.... Any help is appreciated... I hope that I explained my problem good.. Thanx in advance..