hello guys
i'am using dcount in the control source of a form
this is what i wrote
i want to know the number of the records in the table tbl_Sanctions with this criteria
the register date should not be older than 28 days
and first procedure number should be equal or smaller than 15
and the procedures type should be equal to hard
but when i open the form i read #error in the text box if i remove the first procedure and procedures type and just put the register date it will work so the problem with the last two criterias
any help??
i'am using dcount in the control source of a form
this is what i wrote
Code:
=DCount("*";"[tbl_Sanctions]";"[Register_Date] <=Now()-28 AND [First_Procedure_Number]<=15 AND [Procedures_Type] = Hard")i want to know the number of the records in the table tbl_Sanctions with this criteria
the register date should not be older than 28 days
and first procedure number should be equal or smaller than 15
and the procedures type should be equal to hard
but when i open the form i read #error in the text box if i remove the first procedure and procedures type and just put the register date it will work so the problem with the last two criterias
any help??
