Hello:
In a calculated control in a report, I put the following syntax:
(DCount("[Mod received date]","table1","[mod received date]>=[forms]![dialog]![date1]")
This isn't working, I think because I am using dates and need to put in #s? However, what I really want to do is count the mod received date records that fall within the range (between) the user inputed dates entered in a form, i.e. between [forms]![dialog]![date1] and [forms]![dialog]![date2] but I just can't figure out the syntax.
Any help would be much appreciated.
In a calculated control in a report, I put the following syntax:
(DCount("[Mod received date]","table1","[mod received date]>=[forms]![dialog]![date1]")
This isn't working, I think because I am using dates and need to put in #s? However, what I really want to do is count the mod received date records that fall within the range (between) the user inputed dates entered in a form, i.e. between [forms]![dialog]![date1] and [forms]![dialog]![date2] but I just can't figure out the syntax.
Any help would be much appreciated.