I need help setting up an expression in Access.

  • Thread starter access expressions take work
  • Start date
A

access expressions take work

I need help building an expression to count the number of times the word
'Expired' appears in the 'Status' field on a report.
 
T

tina

place an unbound textbox in the footer section (either report footer or a
group footer) and set the ControlSource property to

= Sum(IIf([Status] = "Expired", 1, 0))

hth


"access expressions take work" <access expressions take
[email protected]> wrote in message
news:[email protected]...
 
Top