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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Populating a column based values in an existing column
This just seems to add 14 days to the value in the DATE column and puts this value in the PAY PERIOD END column ie if the DATE is 27/12/2006 it will put the value 10/01/2007 in the PAY PERIOD END column, if the DATE is 28/12/2006 it will put the date 11/01/2007 in the PAY PERIOD END column etc...- mkirwan
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Populating a column based values in an existing column
Hi all, In the organisation that I work for employees get paid every 2 weeks on a Saturday. So for this financial year the pay period end dates have been 8th July 2006, 22nd July 2006, 5th August 2006 etc. I have a column in an Access table listing dates. I want the next column to be...- mkirwan
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
