Access Report - Totals

[taylornow]

I have a report that needs totals. I have all of them except one. The information came from an Excel file and one of the fields consists of the letters "Y" or "N". In the footer I need to be able to separate the Y's from the N's and have a total for each. All the expressions I have tried haven't worked. I can get a grand total but not individual ones. Is there anyway to distinguish between the two and get a total for each ?

thanks a bunch
Taylor

 

[acecce]

I've used the "Count" and "DCount" functions where you count the number of records with "Y" and the number of records with "N"

 

[taylornow]

I tried those but all I got was a grand total. Do I use one for the "y" and the other for the "n"? I think I have tried so many combinations that I have built up a block in my brain and nothing is working. I have a query with the "y" and another for the "n". Could I use the queries somewhere in the expression so it will just pull the total I want ?

thanks

 

[ray436]

I may be wrong, but try something like this;
(the syntax is probably off, its the contents that matters)



=DCount("[FieldofN]","[NameOfNquery]","[FieldofN]='N'&quot

=DCount("[FieldofY]","[NameOfYquery]","[FieldofY]='Y'&quot

hope it helps

Ray