I am trying to create a DB that gives me only saturday dates for the year
2006. I am not sure how to create the formula for this. can anybody help
please
The simplest way to do this is just to use Excel to create the data,
and import it into Access. Create a spreadsheet; enter the first and
second saturday (using a calendar); and use Excel's nifty Fill Down
feature to fill out 52 rows (or 51 or 53, however many it needs).
If you want to do it in Access, create a little utility table Num with
one field N; manually fill it with numbers 0 to 100 (or
programmatically or in Excel, 0 to 10000 - it's a handy table for a
lot of reasons). Create an Append query:
INSERT INTO tblSaturdays (Datefield)
SELECT DateAdd("d", [N] * 7, #1/1/2006#)
FROM Num
WHERE DateAdd("d", [N] * 7, #1/1/2006#) < #1/1/2007#;
John W. Vinson[MVP]
