Automatic Query

[Djbell]

Hi All

I have a linked table that links to a CSV file, which imports the data in the following structure!

Item No Name Price Quantity
1111 ItemA 20 20
21 23
25 26
2222 ItemB 11 31
10 36
333 ItemC 5 16
3 11


What I would like is to create a query so that it does the folowing with the information.

Item No Name Price Quantity
1111 ItemA 20 20
1111 ItemA 21 23
1111 ItemA 25 26
2222 ItemB 11 31
2222 ItemB 10 36
3333 ItemC 5 16
3333 ItemC 3 11

Is this possible?

Regards

Djbell

 

[Remou]

You will find several posts on this topic, this one for example:
Fill in Blank Spaces between records
thread701-1062271

 

[Remou]

Please do not duplicate posts.
Automatic Data fill in Query
thread700-1301469