access 2000 adding count fields into a report

  • Thread starter Thread starter marnita F via AccessMonster.com
  • Start date Start date
M

marnita F via AccessMonster.com

Hi Guys,

I need help with adding count fields to my report. This is the deal. What I
have is a field that is for contracts stating if it was a win, loss, or no
bid. I would like to add fields to my report footer that shows a count of
each (meaning wins, losses or no bids). Is this possible to do? If so how
do I do it.

Thanks!!!
 
You can add a text box in a group or report header or footer section with a
control source like:

=Sum( Abs([field that is for contracts stating] = "win") )
=Sum( Abs([field that is for contracts stating] = "loss") )
=Sum( Abs([field that is for contracts stating] = "no bid") )

Substitute your actual field name above....
 
Back
Top