I need help setting up an expression in Access.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help building an expression to count the number of times the word
'Expired' appears in the 'Status' field on a report.
 
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
(e-mail address removed)> wrote in message
news:[email protected]...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula - Count Dates from another Sheet 8
Calc'd Field on Report 2
Expression Builder in Query 2
Counting number of records based on criteria 2
Nested IIF - more than one conditional....can't do it!!! 5
Conditional expression help needed. 2
re arrange records in Reports for MS Access 2000 9
Reports: How do I eliminate rows where field value count is =>10? 14

Back
Top