I want to graph the totals by week by combination of unique values from the
first four columns. For that I created 4 combo-boxes (not in a form), each
one containing all the possible unique records on that column, I also
included an “all” item in each list for those cases where the user wants to
see “totals” of all columns or certain combinations.
The idea is similar to a pivot table. I concatenated two fields (columns)
and graphed them by using “sumif” now the user is asking for more
“query/filter”options but I don’t find the concatenation of all 4 columns
any practical and besides, I don’t know how to incorporate the “all” to the
“sumif” other than several nested “if’s”
Any suggestions?

The headings of the data is as follows

Cntry- Plnt-Wrhse-Ctgry Week1 Week2 Week…………..

See if this link may shed some light on what you want to do...

http://clem.mscd.edu/~mayest/FIN4200...%20Charts.html


Mark Ivey



"LuisE" <(E-Mail Removed)> wrote in message
news:F8CEDAB4-4144-4686-9829-(E-Mail Removed)...
> I want to graph the totals by week by combination of unique values from
> the
> first four columns. For that I created 4 combo-boxes (not in a form), each
> one containing all the possible unique records on that column, I also
> included an “all” item in each list for those cases where the user wants
> to
> see “totals” of all columns or certain combinations.
> The idea is similar to a pivot table. I concatenated two fields (columns)
> and graphed them by using “sumif” now the user is asking for more
> “query/filter”options but I don’t find the concatenation of all 4 columns
> any practical and besides, I don’t know how to incorporate the “all” to
> the
> “sumif” other than several nested “if’s”
> Any suggestions?
>
> The headings of the data is as follows
>
> Cntry- Plnt-Wrhse-Ctgry Week1 Week2 Week…………..
>
>
>

Thanks. I ended up using DSUM in an avery similar approach.

"Mark Ivey" wrote:

> See if this link may shed some light on what you want to do...
>
> http://clem.mscd.edu/~mayest/FIN4200...%20Charts.html
>
>
> Mark Ivey
>
>
>
> "LuisE" <(E-Mail Removed)> wrote in message
> news:F8CEDAB4-4144-4686-9829-(E-Mail Removed)...
> > I want to graph the totals by week by combination of unique values from
> > the
> > first four columns. For that I created 4 combo-boxes (not in a form), each
> > one containing all the possible unique records on that column, I also
> > included an “all” item in each list for those cases where the user wants
> > to
> > see “totals” of all columns or certain combinations.
> > The idea is similar to a pivot table. I concatenated two fields (columns)
> > and graphed them by using “sumif” now the user is asking for more
> > “query/filter”options but I don’t find the concatenation of all 4 columns
> > any practical and besides, I don’t know how to incorporate the “all” to
> > the
> > “sumif” other than several nested “if’s”
> > Any suggestions?
> >
> > The headings of the data is as follows
> >
> > Cntry- Plnt-Wrhse-Ctgry Week1 Week2 Week…………..
> >
> >
> >