By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 838 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Fill Null Record

P: 14
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.
Attached Images
File Type: jpg Status.jpg (54.4 KB, 61 views)
Feb 13 '17 #1

✓ answered by PhilOfWalton

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

Share this Question
Share on Google+
2 Replies


PhilOfWalton
Expert 100+
P: 1,430
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
Feb 14 '17 #2

P: 14
Ok, I got it to work, thanks.
Feb 15 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.