Working With DatePart and Check Box as criteria for DCOUNT

[jmaher196]

Hello all!

I have a table that is used to track custoemr visits that contains the following fields: [Customer Name] [Date of Visit] [Location] [Topic] [SAFC Rep] and [Visit Completed?]. [Visit Completed is a check box using the Yes/No Format, and the [Date of Visit] field uses the simple mm/dd/yyyy format.

On a form I have created, I would like to use the DCOUNT function to return the number of Customer visits that have been completed during the current year. So if the [Visit Completed?] box is checked, and the yyyy for [Date of Visit] falls during the current year I would like it to be counted. Any ideas on how to code the unbound text box?

Thanks!

[Rabbit]

You can use True for checked. And you can use the Year() function to return just the year part of a date.

[NeoPa]

Produce a procedure (We'll call it X for now) that checks the values of [Visit Completed?] and [Date of Visit] and determines the value for the number of qualifying visits to populate some TextBox or other on your form.

Next, call this procedure from all three of :

1. The Form_Current() event procedure.
2. The Visit_Completed__AfterUpdate() event procedure.
3. The Date_of_Visit_AfterUpdate() event procedure.