By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,657 Members | 1,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,657 IT Pros & Developers. It's quick & easy.

Combining Records into a new table

P: 2
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.
Jul 6 '07 #1
Share this Question
Share on Google+
3 Replies


P: 2
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.
Jul 13 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jul 17 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Jul 17 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.