Hi Guys,



I want to create a small data base, I want to add data to empty fields on a spread sheet, when i save the data it should save it in a list, and clear all the fields so that I can add another task/event to keep track of what happens during the days.

Any suggestions? I haven't used access in a long time to create a data base.

Purpose of the sheet is, we have technicians in the field, and after each site visit i want to add the details in a list and it must save in a list so that I can refer back to what work has been done or not.

Basic things like, Date, time, site, description, etc. I can add more stuff later what would be needed, but just need an example of how to do it.

Regards

This sounds like fairly basic spreadsheet design - simply create a new workbook, add headings to each column for the attributes you want to record, then start recording the details in each row below those headings. This has nothing to do with Access.

As for "and clear all the fields so that I can add another task/event to keep track of what happens during the days", it's not at all clear what you mean. In Excel, you can simply keep adding data to new rows - up to 1048576, in fact. If you've finished with some data, you can simply delete those rows.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks, I started to use google drive, the calendar and just adding the data there.

Our technicians swap and install electrical meters, we have about 3000 meters in the field, in the empty fields i wanted to add all the meter details with vlookup, and dropdowns, times should automatically be saved when the empty fields were filled in.

Im working in a high pace environment and wanted to make my tasks easier. Thanks for the advice, will play around and see what I can come up with.

Regards