Need An Ideal!

  • Thread starter Thread starter DavidW
  • Start date Start date
D

DavidW

How would you go about having a form that you could use two different
comboboxes to select two different items and pull monthly or yearly data to
compare against one another
Thanks In Advance
David
 
David,

Allow me to begin the other way around: to compare two (or more) different
items, I would use a crosstab query that sums the items' sales (or whatever)
and and uses the items themselves as column headers, so I get them side by
side.

Now, to use the combos as criteria for the query: in the query criteria line
for item, I would have to enter:

= Forms!InputCriteriaForm!Combo1 or Forms!InputCriteriaForm!Combo2, or
= Forms!InputCriteriaForm!Combo1 and <= Forms!InputCriteriaForm!Combo2 (for
Click to expand...
a range)

etc.

I hope this gives you a starting point to build on, if you like the idea
(there are others!).

Nikos
 
Create a query that includes the data fields you want to compare. Then pull down
the date field again so that you have the date field twice in your query. In the
first date field criteria put:
NameOfFirstCombobox
and in the second date field criteria put:
NameOfSecondCombobox

When you have multiple fields with criteria in a query, each criteria is
evaluated as AND.
 
Back
Top