Hi
I have a calculated Field query which groupes all the different order types by the first char A, B, C, & D with the corresponding total sums for each order type.
Now I would like to have a form which displays each order type & the corresponding sum value for each type via a text box. I am unsure of how to do this.
I have three different queries similar to above which I also would like to show the values off on the same form. (Show order type + Sum total for each)
All the queries have a parameter query in the date field to enter a From & a To date. Is it possible to only enter the date once when the form is run for all 4 queries?
I have tried making a form and including each query as a subform, but I have to enter the To & From dates 4 times which is not what I want. Any ideas Please ??
Any help would be most appreciated
I have a calculated Field query which groupes all the different order types by the first char A, B, C, & D with the corresponding total sums for each order type.
Now I would like to have a form which displays each order type & the corresponding sum value for each type via a text box. I am unsure of how to do this.
I have three different queries similar to above which I also would like to show the values off on the same form. (Show order type + Sum total for each)
All the queries have a parameter query in the date field to enter a From & a To date. Is it possible to only enter the date once when the form is run for all 4 queries?
I have tried making a form and including each query as a subform, but I have to enter the To & From dates 4 times which is not what I want. Any ideas Please ??
Any help would be most appreciated
