If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
auto-populate a table?
I want to design a table with two fields. Field 1 is a number and Field 2
is a date/time field. Field 1 is merely a shortened version of Field 2 that I use to conserve keystrokes. Example: Field 1 Field 2 7 7:00 am 715 7:15 am 730 7:30 am etc. (Using this "conversion" table, I can simply type in "7" and it will store as 7:00 am. Fortunately, all the times I need are within a 12-hour period, so I'll never need a 7:00 pm.) Now, being the lazy person that I am, I'd like to automatically populate this table, or at least Field 2, in 5 minute intervals from 7:00 am through 6:55 pm, without having to manually enter all those times. Can it be done and how? Is it possible to do it first in Excel and then inport the table? Thanks in advance for your creative solution! Jerry |
#2
|
|||
|
|||
In the infamous words of Gilda Radner, "Never mind."
I figured it out using Excel and then importing. Jerry |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |