Hi, everyone. I´m fairly new to Access and I need help with some code for DCount. I have a form named FormAnalystsEval with text boxes named AJDNumPending, TxtBeginDate and TxtEndDate. The user enters a start date in TxtBeginDate and an end date in TxtEndDate to specify a date range. I want to have a button that if you press it, it will give me the number of records from QueryAllPendingCases where the Partner name is AJ Dallas and the date falls between the two values on the FormAnalystsEval form. Can someone please help me?

Here´s the code I have:

AJDNumPending.Value = DCount("[Case_Number]", "QueryAllPendingCases", "[Partner] = ´AJ Dallas´ AND Between [Forms]![FormAnalystsEval]![TxtBeginDate] And [Forms]![FormAnalystsEval]![TxtEndDate]")


Thanks in advance.

Aprile
www.accessdatabaserepair.com - Access Repair Tool

You mean, dcount? Try this one:

You need to keep the form dates as values.

HTH,


Hailey
www.msaccessrepair.com - Access Recovery