Hello how can i make an ms access Table that every user that i add to have one cell that is the start date of school and automaticly to calculate the date of the end of semerster (3 months)and automaticly display the end day of course (6 months)
Hello how can i make an ms access Table that every user that i add to have one cell that is the start date of school and automaticly to calculate the date of the end of semerster (3 months)and automaticly display the end day of course (6 months)
Cell is a spreadsheet term.
You don't store calculated values with database - you calculate when needed via a query.
Suppose you had a table tblSchoolYear with a field StartDate type date
You could use a query
Code:Select StartDate , DateAdd("m",3,StartDate) as EndOfSemester , DateAdd("m",6,StartDate) as EndOfShoolYear from tblSchoolYear