Search results

Thanks for your responce. I can normalize the text items but cannot do the normalization to the dates in table three because they will be equial to or less than the dates in table two to return the correct answer. :confused:

I have two tables that will contain the information that I need the third table that will be used for constant data entry to auto fill in two of the fields (Class, Rate)based on four criteria from the first two. Table 1 EmpID Name 1 EMP1 2 EMP2 Table 2 (A Subtable of Table1...

Hello everyone new to access:)