Access MS Access Lookup problem


Joined
Aug 11, 2008
Messages
1
Reaction score
0
Hi All

I would like to kindly request your assistance with a problem that i am having.

I have some data that i have imported into an access table. The data looks a bit like this:

Field1....... Field2
Heading1...........
............... Item1
............... Item2
Heading2...........
............... Item3
............... Item4
............... Item5
............... Item6

I need to be able to populate Field1 like this:

Field1 Field2
Heading1
Heading1 Item1
Heading1 Item2
Heading2
Heading2 Item3
Heading2 Item4
Heading2 Item5
Heading2 Item6

The file imported, will be re-imported often and is quite large.

Does anyone know of anyway this can be done via a query, or VBA function?

Many thanks
 
Last edited:
Ad

Advertisements


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

Top