I receive a daily excel file that I have to pull into Access, where the file is appended to another table. One of the fields required is a status for that product. The excel file does not list the status for each order, but, they are in order by status (a status does appear for the first order always). I need to be able to fill all the null fields with the status listed in the previous record (please see the attached screen shot). I'm not quite sure how to go about this. Thank you.
-
-
I think the easiest way to do this is in code reading each record from your Excel file and saving the last non null value of the status. When you add a new record, you add that saved value of the status and the order number.
What concerns me is that if you add new files each day, presumably the Order will move from created to processing to ??? and will therefor appear more than once.
Assuming that your Order number is unique, you may have to see if that order number is already on file and than change it's status.
Phil -
Ok, I got it to work, thanks.Comment
Comment