Combining Records into a new table

[jde357]

I have MS SQL data that I'm ODBC querring into Access to allow some simple reporting to be done on the data.

That data is event driven, so I get records that the particular event is concurrent.

My querried table has columns for example:

ID
Event
Start Time
End Time

Once the querry is run, I'd like to combine the events that occur within say 10 min. of each other into one record, taking the start time for the preceeding record, and the end time from the following record, leaving only one record out of two in another temp table or querry.

Is this possible?

I'm running Access 2002.

[jde357]

I have MS SQL data that I'm ODBC querring into Access to allow some simple reporting to be done on the data.

That data is event driven, so I get records that the particular event is concurrent.

My querried table has columns for example:

ID
Event
Start Time
End Time

Once the querry is run, I'd like to combine the events that occur within say 10 min. of each other into one record, taking the start time for the preceeding record, and the end time from the following record, leaving only one record out of two in another temp table or querry.

Is this possible?

I'm running Access 2002.

[MMcCarthy]

I have MS SQL data that I'm ODBC querring into Access to allow some simple reporting to be done on the data.

That data is event driven, so I get records that the particular event is concurrent.

My querried table has columns for example:

ID
Event
Start Time
End Time

Once the querry is run, I'd like to combine the events that occur within say 10 min. of each other into one record, taking the start time for the preceeding record, and the end time from the following record, leaving only one record out of two in another temp table or querry.

Is this possible?

I'm running Access 2002.

You would need to use VBA code to do this as you are trying (I assume) to combine the text description of the events into one record. You can't do this using a query.

Have a look at the following article.

http://www.thescripts.com/forum/thread640105.html

[MMcCarthy]

I have merged your two threads together.

Please don't double post. If you don't get a response to your thread within a reasonable length of time post a reply to bump it up the list.