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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

form/subform problem 1
Last Rec or New Record 7
LinkMasterfields/Childfields property - Example? 2
Combobox Weird Behaviour 1
To Ken Snell 2
Trapping no Result 2
4 combo boxes need and/or query for single or multiple sorts 6
user form, saving values 3

Back
Top