Query

[Alexandre Saillant]

Hello,

I have a database that look like this:

1111 A ps32
B PS32
2222 A PS43
3333 A PS23
B PS23
C PS23

I need to convert this to a workable Query so it look like this:


1111 A ps32
1111 B PS32
2222 A PS43
3333 A PS23
3333 B PS23
3333 C PS23


How do I do this?

 

[John Vinson]

Hello,

I have a database that look like this:

1111 A ps32
B PS32
2222 A PS43
3333 A PS23
B PS23
C PS23

I need to convert this to a workable Query so it look like this:


1111 A ps32
1111 B PS32
2222 A PS43
3333 A PS23
3333 B PS23
3333 C PS23


How do I do this?

It's probably impossible, in Access. Tables (not "databases", a
database is the .mdb file containing your tables and other objects)
have no order so - based on the data in your table - there is no way
to ascertain which of the B records should e 1111 and which should be
3333.

If you can import or copy & paste your data into Excel, you should be
able to fill-down there (since rows in Excel DO have a defined
sequence), and reimport into Access.