I have been trying on and off for months to make an Access DB handle this and I really want to get it finished. Here's my vision:
There are other fields I'd like to track. For instance, material delivery date, installation schedule date, issues, person assigned to, etc.
- I have data from a partner company website that I can download into Excel workbooks. Each line is for a specific job number (there are over 4000 right now, and 27 fields for each one).
- Every day, certain fields change for certain job numbers (status, dates, dollar amounts, etc)
- Every day, new job numbers are added (maybe 5-10 a day)
I can't just type these in the spreadsheet because tomorrow, some of the related fields may have changed.
What I'd like is an access DB in which I can import the newest spreadsheet each day. Then have a table (or several tables) that have the "other fields" I mentioned above. Then, I'd like to have a form in which I can add and edit information.
Each time the main import is updated, those changes are reflected in the form, along with the added "other fields" which are all combined in an easy to read form.
Make sense? So how do I go about making this 2nd table and marrying it all together in one form?
Thanks,
Jeff