criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a database (wardlist) with various names. one of the text boxes
associated with the each name is a complications box. to count the number of
complications that are entered I have used the following expression:
=DCount("[Name]","Wardlist","[Complications]>'0'")

Each name is also associated with a date.
What I want to achieve is to count all the complications after a certain
date. that is have a date picker box in which I can select a date and then
get access to count the number of complications occurring after the selected
date.

Help please
Dennis
 
Try this

=DCount("[Name]","Wardlist","[Complications]>'0' And [Date Field Name] > #"
& [Date text box name] & "#")
 
Dennis said:
i have a database (wardlist) with various names. one of the text boxes
associated with the each name is a complications box. to count the
number of complications that are entered I have used the following
expression: =DCount("[Name]","Wardlist","[Complications]>'0'")

Each name is also associated with a date.
What I want to achieve is to count all the complications after a
certain date. that is have a date picker box in which I can select a
date and then get access to count the number of complications
occurring after the selected date.

Help please
Dennis
Click to expand...

=DCount("[Name]","Wardlist","[Complications]>'0' AND DateFieldName > #" &
Me!DatePickerControlName & "#")
 
Back
Top