Should I use Excel or Access
Currently I'm attempting to determine how to easily be able to enter data
either in Excel or Access. I'd use the Data form tool in excel however I'm
using a scanner that's configured to send an enter command after a
successful scan so it would move to the next cell.
Serial Number Employee Time
123 Brian 8/20/13 8:49:21 PM
213 Brian 8/20/13 8:49:21 PM
334 Nick 8/20/13 8:49:21 PM
I'd like to be able to have an accurate time that the serial number was
scanned. As it is right now every time a change was made on the sheet the
time updates which really defeats the purpose. I'm currently using this
formula:
=IF(A2<>"",NOW(),"")
I'd also like to be able to make the employee name able to be changed but
also stay the same during the time when that person is scanning the items.
I tried just referencing a dropdown list but, when that field changes so
does the rest of the employee field.
I'm guessing that this would be best suited for Access because eventually
this will be located in different locations and I'd need to be able to
correlate the data.Honestly, I'm just too unfamiliar with it to be able to
really create something amazing and have it work.
Any help would be GREATLY appreciated.
No comments:
Post a Comment