M
munscher
I have an Excel SS that is essentially a form to be filled out with multiple entries. The SS is formatted in such a way (each entry in Excel covers 2 rows due to merged cells with exception to name and adress which are one on top of another) that when the data is imported to Access it places all information in their respective 15 fields (F1 through F15) and then places the address in field 4 (F4) by itself as its own record. I run a query to get rid of blank records (form has 25 spots, only a few are filled in).
Now, how can i take that address that is all alone as its own record, and add it onto the record directly above it as another field so that i can then sort the records? Whether its done in the initial Table or in the Query is unimportant to me, so either way works. Any ideas?
Now, how can i take that address that is all alone as its own record, and add it onto the record directly above it as another field so that i can then sort the records? Whether its done in the initial Table or in the Query is unimportant to me, so either way works. Any ideas?