I have a MS Access 2000 dbase that I need to extract specific data out of a text field. Below is an example of a record in this field:
The user jsmith connected on port COM2 on 05/22/2001 at 09:11am and disconnected on 05/22/2001 at 09:12am. The user was active for 0 minutes 39 seconds. 30067 bytes were sent and 6787 bytes were received. The port speed was 24000. The reason for disconnecting was administrator's request.
I would like to extract the connection time "0 minutes 39 seconds" and the port speed, which is "24000" and put this information in their own field so I can pull averages of the connection time and port speeds.
How do I go about doing this in Access??
Thank You,
Bill
The user jsmith connected on port COM2 on 05/22/2001 at 09:11am and disconnected on 05/22/2001 at 09:12am. The user was active for 0 minutes 39 seconds. 30067 bytes were sent and 6787 bytes were received. The port speed was 24000. The reason for disconnecting was administrator's request.
I would like to extract the connection time "0 minutes 39 seconds" and the port speed, which is "24000" and put this information in their own field so I can pull averages of the connection time and port speeds.
How do I go about doing this in Access??
Thank You,
Bill
