Search results

  1. C

    IF and Then Statement to pull records based on date match in table

    Thank you to both of you! I just ended up doing a query then using a Subform.:)
  2. C

    IF and Then Statement to pull records based on date match in table

    Thank you Galaxiom! I think your reply would work the best. However, what is "somefield" in the code below. The field I want to count is the "WorkType" field. SELECT Count(somefield), WorkType_fld FROM NIGO_Data WHERE WorkType="Completed" AND [datefield] = Date() GROUP BY WorkType_fld
  3. C

    IF and Then Statement to pull records based on date match in table

    Hi sorry, I am new. It's not finding the current date. If I take out the "if then statement" the Countit wrks perfect. It's not filtering the date by date. Thanks Chinelo
  4. C

    IF and Then Statement to pull records based on date match in table

    Good Afternoon, Hoping someone can assist with this simple code. I cannot get the If then statement to work. I have a table called "NIGO_Data" on the table there is a field called "SubDate" which holds the date of the record. I want my if then statement to search the NIGO_Data Table and...
  5. C

    SUM Query with IF and Then Statement

    Good Afternoon, I am new to Access and was hoping to get some help with a query. I have a form built with a sum button. When button is clicked I want it to count all records when a match is found in the HandledType_fld. Example: "HandledType_fld" can have Completed, Handled, NoAction etc...
View older results
Back
Top Bottom