Search results

  1. J

    Date field updates with day

    I have a form field that the user inputs the date in. I have another field that will change this number date to the actual day of the week but this field is dependent on the date field so it does not update in the table. How can I get the day field to update in my table so I can query off of...
  2. J

    Grouping date range

    I have a query that includes a date field, a status field, and a count field. I am trying to write a query that will return the total number of times a certain status is used in a given date range. The problem is that the status are used throughout the date range so my query returns a 1 or...
  3. J

    Auto Update date when another field is changed

    I have 2 fields on a form. One is the Account Status which is a drop down list box and the other is Date Status Updated. I would like for the Date Status Updated field to automatically update to the current date when a selection is chosen or changed in the Account Status field. Is this...
Back
Top Bottom