counting records according to field value

[mark]

Calling all Geniuses (Geni !!)

particularily Marsh, thanks for your help last time, Top
Banana !

I want to be able to have a txtbox containing the total
number of rows that have a specific value.
Specifically, I have a form displaying a list of all the
current jobs in our production system. I already have a
txtbox in the footer, using Count(*), that counts up all
the rows (production jobs) in total ......but I want to
have a similar txtbox that displays the total amount
rows/records that are due to for delivery this month. (one
of the fields in the records is a 'Delivery Date' field)
I have got close to a result, but so far, I can only total
up the amount of records that are currently on screen, but
I need a solution that counts all the records in the
Query/Form...according to the 'delivery date' argument.

thanks

Mark

 

[PC Datasheet]

Mark,

Put this expression in the control source property of your textbox:

=DCount("*","TblJobs","Month[DeliveryDate] = Month(Date()")


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel