G
Guest
Access 97. I've got two tables. The first table has 3 fields. Sample data as
follows
A 06/01/2005 06/07/2005
B 06/08/2005 06/15/2005
D 06/16/2005 06/23/2005
The second table has 2 fields. The first is a date. The second needs to
look-up from the first table Field #1. In essence if Table 2 has 06/03/2005
in it then I want to place an A in Field 2 of Table 2. If Table 2 has
06/08/2005 then I want to place a B in Field 2 of Table 2. Any help would be
appreciated.
follows
A 06/01/2005 06/07/2005
B 06/08/2005 06/15/2005
D 06/16/2005 06/23/2005
The second table has 2 fields. The first is a date. The second needs to
look-up from the first table Field #1. In essence if Table 2 has 06/03/2005
in it then I want to place an A in Field 2 of Table 2. If Table 2 has
06/08/2005 then I want to place a B in Field 2 of Table 2. Any help would be
appreciated.