manipulate data to put into a table

W

WSC

I have 2 tables with data that need to be joined. One table has hourly
information and another table has daily information. I need to have the table
with daily information broken out into hourly information. For each date
range i.e. 10/19/06 21:51 - 10/20/06 6:19, I need to have the minutes for
each hour. All of this info needs to be put into a table. the date range of
data to be pulled is in a form that the user fills in. START_DATE and
END_DATE.

Any ideas how to accomplish this? I was thinking that I could do some sort
of loop to write to a table for every date range within the selected range.
Would this work? What is the right code?

Thanks so much!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Append Crosstab Query to Existing Table 0
Insert Index into a Table 1
Add additional information to excel form after original data entry 0
Linking data in MS Word into Excel 5
Creating a Chart on form from selected data in query. 0
Setting column width in a table with a macro is not working 0
How to have two tables on same line? 1

Top