Something of a beginner - so please excuse if this is a lack of basic knowledge
I have a table containing ID values 1 to 8 each with a text value which appear as text in a combo box on a form
These numeric values then appear in a 'MembersDetails' table
I am trying to write a query to give three outputs from MembersDetails
Count of Total Records
Count of Records where ID = 1 or 5 or 6 or 7
Count of Records where ID = 2 or 3 or 4 or 8
With three three values put into a report generated by a button click.
I have tried the Count function in the Totals line of a query but as this is all coming from the same table I can't get the desired result - either nonsense answers or errors.
Can anyone offer help that a relative beginner can follow.
Many thanks in anticipation
I have a table containing ID values 1 to 8 each with a text value which appear as text in a combo box on a form
These numeric values then appear in a 'MembersDetails' table
I am trying to write a query to give three outputs from MembersDetails
Count of Total Records
Count of Records where ID = 1 or 5 or 6 or 7
Count of Records where ID = 2 or 3 or 4 or 8
With three three values put into a report generated by a button click.
I have tried the Count function in the Totals line of a query but as this is all coming from the same table I can't get the desired result - either nonsense answers or errors.
Can anyone offer help that a relative beginner can follow.
Many thanks in anticipation