Need help on MS Access form/report to display the totals from the criteria of the input selected
I have a UserTable which has filed user, company, dept, contact

--> Here dept(filed1) and company(filed2) are combo boxes to choose set of the diff input values.

** Now I want to prepare a MS access report/form to display the Total users count if I choose any of the one field or both..

Can some guide me the code.. How to implement this through VBA code using sql query syntex in the background of MS access forms/report.

Thank you in advance
Need help on MS Access form/report to display the totals from the criteria of the input selected
===

I have a UserTable which has filed user, company, dept, contact

--> Here dept(filed1) and company(filed2) are combo boxes to choose set of the diff input values.

** Now I want to prepare a MS access report/form to display the Total users count if I choose any of the one field or both..

Can some guide me the code.. How to implement this through VBA code using sql query syntex in the background of MS access forms/report.

Thank you in advance