Search results

  1. D

    Null field causing data mismatch

    I am trying to avoid a data mismatch for my query. The portion of the query (query2) causing the problem is: SELECT Date()-[caAssignmentDate] AS AsgnAge FROM Query1 WHERE (((Date()-[caAssignmentDate])>10)); If I remove the WHERE portion, it works fine. If I remove the null records from the...
  2. D

    VBA Import Excel Files - Update Worksheet Names?

    Hello, I have 4 excel files I run /w VBA to import. The issue is 2 of the files have their worksheet name change every day by the system I am exporting them from. My original macro was very simple... DoCmd.RunSavedImportExport "123" DoCmd.RunSavedImportExport "456" DoCmd.RunSavedImportExport...
Back
Top Bottom