domain aggregate

  • Thread starter Thread starter Cold1
  • Start date Start date
C

Cold1

I am an access newbie and have run aground trying to do a
domain aggregate function that uses the values from 2
combo boxes as criteria.
It will work fine for me with one criteria at a time:

=davg("Max","Data","Month= " & [cbo1])
=davg("Max","Data","Day= " & [cbo2])

How can I get Month = cbo1 AND Day = cbo2 ? I would think
this must be possible. What is the correct syntax?
Any help would be appreciated. Thanx
 
Cold1 said:
I am an access newbie and have run aground trying to do a
domain aggregate function that uses the values from 2
combo boxes as criteria.
It will work fine for me with one criteria at a time:

=davg("Max","Data","Month= " & [cbo1])
=davg("Max","Data","Day= " & [cbo2])

How can I get Month = cbo1 AND Day = cbo2 ? I would think
this must be possible. What is the correct syntax?
Click to expand...


=davg("Max","Data","Month= " & [cbo1] & " AND Day= " &
[cbo2])
 
Back
Top