Hello,
I have setup a brief example in excel to show what i would like to achieve in access.
I need a table that would store all data on a test related to the same pieces of equipment every year. Each year we will perform said test with a form that access would generate on a report to carry in the field. once done the data would be brought back to the office and entered into the database, preferably with the same layout as the report for ease of entry.
See image "Test Form"
Once this data is entered the "Test Report" will be view able to show all data accrued.
the Equipment ID's are from an existing table [tblEquipment]
I have setup a brief example in excel to show what i would like to achieve in access.
I need a table that would store all data on a test related to the same pieces of equipment every year. Each year we will perform said test with a form that access would generate on a report to carry in the field. once done the data would be brought back to the office and entered into the database, preferably with the same layout as the report for ease of entry.
See image "Test Form"
Once this data is entered the "Test Report" will be view able to show all data accrued.
the Equipment ID's are from an existing table [tblEquipment]
