Search results

Hi, I want to have an index such that the combination of "line no" and "calving date" are unique. I have tried: CREATE UNIQUE INDEX index1 ON [main table] ([Line no], [Calving Date]) ; And CREATE INDEX index1 ON [main table] ([Line no], [Calving Date]) WITH PRIMARY; but I get a unique...

Hi, I have not used Access for over 10 years! I am using Access 2000 to look at tracking cow weight over time! There are 2 tables: - main table - weight table I want to set the main table's January weight to a value from the Animal weight table (logical expression): UPDATE [main table] SET...