D
Devon
Hello
I work with the Server logs for my company. I run weekly reports of this
data, and send the results to people throughout the company. I am working on
enhancing some of the reports to show trends based on the time of the day.
One of the tables that contains the server data contains one column with the
date, and a separate column with the time (date is Long Date, and time is
Long Time).
I would like to create a separate table within the database that contains
time. I am thinking that the first column in this table would contain Time
in Long Time format (column would be used to link up to the Server table),
the second column would contain Time in Short Time format, and the final
column would contain Time in (hh AM/PM) format. The reason for this table
would be for doing an equi-join to the server table where I would be able to
show in a report how many Server logs come in at any given hour to look for
trends or potential problems.
My question involves how to create the Time in Long Time format where it
shows every second of a 24 hour period with AM/PM. Initially, I tried to
create the table in MS Excel, so that I could use the autofill option. This
appeared to work, however, when I imported to MS Access, none of the data in
this table works in the equi-join query with the Server table. My guess is
that it is somehow due to the format, however, on the surface, everything
looks the same. If I manually enter the data into MS Access, it works, but I
would like to find a way to programmatically accomplish the time table. The
thought of manually entering 80,000+ rows of data doesn't sound too exciting.
Any ideas?
For an example, please use the following:
S Table for Server Table
LTime for Long Time column
STime for Short Time column
HTime for Hours Time column.
Thanks in advance
Devon
I work with the Server logs for my company. I run weekly reports of this
data, and send the results to people throughout the company. I am working on
enhancing some of the reports to show trends based on the time of the day.
One of the tables that contains the server data contains one column with the
date, and a separate column with the time (date is Long Date, and time is
Long Time).
I would like to create a separate table within the database that contains
time. I am thinking that the first column in this table would contain Time
in Long Time format (column would be used to link up to the Server table),
the second column would contain Time in Short Time format, and the final
column would contain Time in (hh AM/PM) format. The reason for this table
would be for doing an equi-join to the server table where I would be able to
show in a report how many Server logs come in at any given hour to look for
trends or potential problems.
My question involves how to create the Time in Long Time format where it
shows every second of a 24 hour period with AM/PM. Initially, I tried to
create the table in MS Excel, so that I could use the autofill option. This
appeared to work, however, when I imported to MS Access, none of the data in
this table works in the equi-join query with the Server table. My guess is
that it is somehow due to the format, however, on the surface, everything
looks the same. If I manually enter the data into MS Access, it works, but I
would like to find a way to programmatically accomplish the time table. The
thought of manually entering 80,000+ rows of data doesn't sound too exciting.
Any ideas?
For an example, please use the following:
S Table for Server Table
LTime for Long Time column
STime for Short Time column
HTime for Hours Time column.
Thanks in advance
Devon