Function calculation part

[azhar2006]

Hello Guys
I am trying to put a text box on a form showing me a certain data


Subfamily of blood groups in certain scale effect in the sense Finished
The vial of blood has been stored in the refrigerator to save more than 35 days
I wrote this function, but to no avail
= DCount ("*"; "tblsettlors"; "(donor = 'o +') and Between Date () And DateAdd (" d "; -35; Date ())
Any help
Thank you

[John_G]

Hi -

1) You are missing a field name in the DCount WHERE, and
2) (I think) the semicolons in the DateAdd function have to be commas, and
3) The semicolons in the DCount have to be commas,
4) Remove the blanks in the " d " in DateAdd, and enclose the d in quote mark pairs
5) You are missing a closing quote in the DCount where

= DCount ("*", "tblsettlors", "(donor = 'o +') and field_name_missing_here Between Date () And DateAdd (""d"", -35, Date ()")

If you are using a language setting other than English, my observations regarding semicolons and commas might not be right.

But the biggest problem there is that you did not indicate which field has to be in the date range.

HTH

John

[azhar2006]

Thank you very much John
for your reply
Yes, the field name is (DonorDate)
But when you insert the expression, this message appears

= DCount ("*", "tblsettlors", "(donor = 'o +') and DonorDate= Between Date () And DateAdd (""d"", -35, Date ()")

[John_G]

Hi -

I took another look - there is also a missing ")" in the DCount (in red below):

= DCount ("*", "tblsettlors", "(donor = 'o +') and field_name_missing_here Between Date () And DateAdd (""d"", -35, Date ())")

HTH

John

[azhar2006]

Thank you John
But not prospered
Is it possible a small example