Counting a specific option from an Option Group

[amc1902]

Hello all,



New to this forum and to the world of Access. Slowly finding my way!!!

I am developing a database using Access 2003. I am using an Options group with two option buttons, 'ongoing', using value 1 and 'complete', using value 2. The users of the database will be required to select one of the two.

I'm trying to build a query that will return a count of 'ongoings' (or the 'completes' if / when required) - probably an easy one for somoebody on here!!!

Any help would be greatly appreciated

Thanks

[ranman256]

The options are put in a FRAME. (the square box with a lable) make sure you know the frame.name from properties.
the FRAME.VALUE is which option got picked.

select case frame.value
   case 1
        docmd.openquery "qsOpen"
    case 2
        docmd.openquery "qsClosed"
end select

[amc1902]

Thanks for your reply......like I was saying, new to Access so will need everything 'dumbing down'

The frame for the options group is called 'BF or PA'
The options buttons are 'ongoing' and 'complete'

I am trying to put the query together using the query design view. Can your suggestion be adapted to fit as my coding is basic to say the least.

thanks

[June7]

Use the query designer to build an aggregate (GROUP BY) Totals query. Access Help has more guidelines.

What field has the values 1 or 2? If you want a dynamic parameterized query that references the option group on form:

SELECT Count(*) AS CountRecords WHERE fieldname=Forms!formname![BF or PA];

[amc1902]

Many thanks for your help!!! Got it with the GROUP fucntion, then using the field values '1' or '2' in the criteria.

Much appreciated!