Dear Friends,
I have a Form which contains a textbox i.e. named as FR_DATE, when user click on the textbox Access allow user to select a Date from Default Calendar
Support I need here is: -
The Moment any user selects a date in FR_DATE textbox, keeping selected Date as a Criteria; How many Rows Same Records are available in “FIRMORDERS” Table Ref_Date Column must be counted and gets reflected in Text15 (That is where I have below highlighted Formula).
Currently Text15 always display Zero Only! Please suggest me with an revised Expression Builder which I can update on Text15 Control Source!Code:=IIf([FR_DATE]>0,DCount("[Ref_Date]","FIRMORDERS","[Ref_Date]"="[FR_DATE]"),0)
Thanks & Regards,
Rajeshkumar R