What you're cited from help, I've found, the DCount("YourField", "YourTableorQuery", "YourCriteria")
but, as luck would have it, I need more complex functions. For instance, I have a DCount function as follows:
=DCount("[resultelisa]","Main","[resultelisa] = 'Positive'")
I need to know if I can put another condition on the end to allow the user to select date parameters for this function to run. Something like:
=DCount("[resultelisa]","Main","[resultelisa] = 'Positive' AND
[dtelisa] BETWEEN {choose beginning date} AND {choose ending date}")
I know this is all wrong, but is something like this possible? This is used as a calculated field on a report that counts all the ELISA Positive samples between two dates.