Counter to tell me how many records my filter will find.

[Bopsgtir]

Hi all, i currently have a form that shows me how many records have missing data, on the menu form there is a traffic light system so when you click green it opens my form and shows all records under 20 days old amber does 20 to 30 and red over 30.

Now what i want is 3 counters on that form so you dont have to click the buttons it would tell you how many records each filter would find.

All help would be greatly received.

 

[John Big Booty]

Perhaps this article will give you some pointers.

 

[Bopsgtir]

Ive tried to put the below in the control source of my text box but it brings a #NAME error


=DCount([QryMissingData]![First_Name],[QryMissingData],[QryMissingData]![Start_Date] Between Date()-14 And Date()-20)

 

[John Big Booty]

Check this link for the correct syntax for using multiple criteria in the DCount() Function.