Recent content by mcinta19

  1. M

    Query Date Criteria: Before the Previous Friday

    I tried that and it gave me an error message.
  2. M

    Query Date Criteria: Before the Previous Friday

    I need to run a query that returns all the results that have a due date on or prior to the Friday of the previous week. Any help would be appreciated.
  3. M

    Setting a Yes/No based on Null data in multiple fields

    I am new to Access and I have to create a database that tracks the progress of incoming members for an organization. One of the things I need to keep track of is whether or not they have completed all 4 of the mandatory orientation sessions. I have a table Tbl_Orientation that contains a date...
  4. M

    Set default value in form to value of another field

    There is a Date field in the Table. Now I am not getting an error but the field is still not populating.
  5. M

    Set default value in form to value of another field

    I fixed the code but I still get an error. I cannot add a specific date as in the example because the dates are always different. =DateAdd("m",1,[Date])
  6. M

    Set default value in form to value of another field

    I tired adding the DateAdd to the default value but I got an error. This is what I used. I'm not sure the proper way of referring to the field I am pulling the date from and it's not always today's date so I can't use Date(). =DateAdd(1,"m",[Date])
  7. M

    Set default value in form to value of another field

    I have a database that tracks appointment information. When entering information in my form I would like to have the due dates automatically populate. I have a field Letter Due Date that I would like to have automatically set to be the date from another field (Date) + 1 month. There is another...
Top Bottom