I have a table that has the following information
HdrHID = unique ID
ActionCode = this is a variable column that has a specific set of data being either new, acctgrev, or complete
Each header ID can have up to three lines being 1 for each code
I have a query that pulls all records with the acctgrev code
What I am wanting is for the count function to provide a count for every HdrHID where ActionCode = acctgrev, the desired result would either be 1 or 0. I can't seem to get this to work, everytime I use the count function, it provides the total count of records in the table.
Any help on this would be fantastic.