Recent content by carll

  1. C

    Dcount of date field

    You are an absolute hero, thank you, that worked. I did get an error, but had called my new text box "count", not a good idea. Renamed it and all fine. Again thank you. Carl.
  2. C

    Dcount of date field

    Hi This produced a different error: #Type! Carl.
  3. C

    Dcount of date field

    Hi Jiri Thanks for the fast response The table is called Works Orders, so I changed this in your code to: DCount("[ID]","[Works Orders]","[Operations Confirmed Date]=#" & [Forms]![Work Orders New]![Operations Confirmed Date] & "#") I am getting an error: #Name? Thanks Carl.
  4. C

    Dcount of date field

    Hi All I am getting a little frustrated at my own inability, so please bear with me! Upon entering a date on a form I wish to check to see if there are more than, say 8 occurrences of this date, as I cannot ship more than 8 times a day. I first of all created a TOTALS query that referenced the...
See more
Top Bottom