473,399 Members | 3,401 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

Fill Null Record

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, 96 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

2 958
PhilOfWalton
1,430 Expert 1GB
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
Ok, I got it to work, thanks.
Feb 15 '17 #3

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

Similar topics

2
by: Olivia Towery | last post by:
How do I write select statement to choose records with a specific field that is NULL? Example - I want to select all records who do not have any email listed. Thanks, -- Olivia Towery...
1
by: Richard C Buchanan | last post by:
I have a table as follows: - user_id (key) - user_email_address (text) - user_request_date (text) - user_sent_date (time/date) An automated macro...
1
by: Colin Graham | last post by:
I am writing this piece of code to show the previous record on a control on the form but i keep getting the error message "Error 3021 no current record " and the line marked *** gets highlighted. I...
1
by: allyn44 | last post by:
Hello--i have inherited a dataset that has records like below: id locationid 1 7 2 3 5 4 5 6 4
0
by: Mark Donners | last post by:
I have access 2002 database I like to fill a record field in a table with a text when i click a button I have two tables say table1 and table2. I have a form based on table1, it has a subform...
4
by: Tony WONG | last post by:
i use the below formula to add up records which is extracted from SQL by ASP. sumQS = cint(objRS1("Q1S")) + cint(objRS1("Q2S")) + .... but if cint(objRS1("Q1S")) is null, it gets error. i...
0
by: jakev2003 | last post by:
I have a form that has values from many different tables. Here are the tables: - Questions(ID, UserID, Question) - Users(UserID, Name, Email_Address, Other_Info) So when I browse through...
1
by: accessbee | last post by:
(Sorry this is so long, was trying to fully explain the situation) There are two tables that handle information on our clients. Every client has a unique ClientID, and the ClientID is the Primary Key...
4
by: Debbiedo | last post by:
I searched the groups and tried several approaches but still cannot find a solution. I have a table that has several hundred fields that may or may not need to be displayed in a report,...
2
by: dowlingm815 | last post by:
I have a basic query to extract records not equal to form type "Standing Order." However, it doesn't extract the null record(s). I would appreciate any insight? The following is the input data ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.