Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Setting up table with only Saturday dates
- Thread starter mssbass
- Start date
alvechurchdata
Programmer
I use Excel:
Type the first date into a cell
Drag it down and fill a series of cells with dates
Copy those cells from Excel
Paste Append into an Access table
It may not be clever - but it's quick and easy.
Geoff Franklin
Type the first date into a cell
Drag it down and fill a series of cells with dates
Copy those cells from Excel
Paste Append into an Access table
It may not be clever - but it's quick and easy.
Geoff Franklin
- Thread starter
- #3
MichaelRed
Programmer
on the other hand - why? If you know (or can "compute" any Saturday date, all the table (potential) entries can easily be derived directly. The calculation of the next / previous date of any selected DayOfTheWeek has been posted severally in these fora, reasonable use of search / advanced search is highly recommended for this pursuit.
MichaelRed
MichaelRed
- Status
Similar threads
- Locked
- Question
- Question