Access Query

[JoeCL]

Hello!

I don't know if this is the right newsgroup but I can't find a newsgroup for
MS Access query problems. So if anyone can help me I'll truly appreciate it.

My problem is this. I import a text log file into Access from an anti-spam
software. In the log there are 2 records for a user. The first record always
contains the last name and the second the first name. And there are several
same last name with different first name. No I want to combine the last name
from the first record with the first name from the next reccord. How can I do
this? Is there a record number function I can use? Thank you.

 

[Chris Mills]

It sounds like the records are order-dependent, that is Physical Order.

There is no guaranteed ordering of records in queries (or tables), unless the
query specifies an order, which cannot be physical order.

I think you would have to write code to do the import, reading through the
input records and either adding an ID number or combining the first/second
records. Code doing a sequential read of a log file, can keep track of
physical placement.

Although there is an Autonumber ability for tables, this would not help you to
combine records in pairs.

Chris