Fill blank fields with value from field above it

I

IrishRed

Hello All,
I have a table which has the following fields: CustomerNum, CustFName,
CustLName, CustAdd1, CustAdd2, CustCity, CustZip. The CustomerNumber field is
where I have a problem. The CustomerNumber field that I need to extract is on
one row along with junk data and the rest of the fields are on the next row.
Like this:

123456789 skdjs dafsdfd dfasfsdf ff fgdgfgfd
Jay Jones 18 Main St City St 12345
I am trying to come up with a way to populate the CustomerNumber field with
the value of the field above it when it's blank. This way I could run a query
to give me the CustomerNum (123456789) and the Address information all on one
line. All of my entries are in one state so I can query where St = 'x'

Thanks for looking at this.
 
I

IrishRed

I have no idea what this response was supose to mean. Can anyone else help
out with my original question?

Thanks.
 
I

IrishRed

Thanks anyway, I took the files into Excel and wrote a formula to do this
instead. Much easier for me since the only way I could see doing it in Access
was to write VB code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filling blank fields with data 5
Stripping city from address field and placing into city field 3
Can you replace a null value with the value above it, in mass? 2
blank fields 5
Table Fields using Billkey vs. Billnumber 2
Multiple Selection Criterial Query some with NULL fields 5
value based on pull down field 5
Skipping Blank Fields 2

Top