Record Counter

I have an unbound textbox at the end of my form that counts and displays
records on the form. I have the following code in the control source.

="Total Pieces Received : " & Count([TrackingNumber])

This counts all the tracking number of all the packages that appear under the
TrackingNumber field.
I have another field called Status that is a Yes/No Field. It shows if the
package has been delivered.
I also have another unbound text box that should display the number of
packages delivered.
How can I modify the code above to look under field "Status" and cound the
records with "Yes" value?

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Need Help - Showing students age
    ... For example, to get the average age of class, you ... calculated field like this, to return the age in months (a numerical ... and this in the Control Source of an unbound textbox in the form ...
    (microsoft.public.access.forms)
  • Re: Unable to display values in ComboBox using SQL query from table
    ... If you want to show the name, you can add an unbound textbox to the form. ... Set its control source to ... table each combobox using one field each. ... Private Sub cboPersonID_AfterUpdate ...
    (microsoft.public.access.forms)
  • Re: Subform problems
    ... and an unbound textbox with the control source set to ... A combobox with ONE column. ... >> Then you'd have an unbound textbox and the control source would be ...
    (microsoft.public.access.forms)
  • Re: Conditional formatting problem
    ... make 1 unbound textbox the same size as the real field and delete ... Create a bound textbox control which is not visible. ... If the unbound textbox has its label deleted, ... The example control source code for the visible textbox basically ...
    (comp.databases.ms-access)
  • Re: display data other field
    ... Put this as the Control Source of an unbound textbox on your main form: ... > How could I show field data from a child table where ID_child equals ...
    (microsoft.public.access.formscoding)