maintt

You are posting things to your own profile which most people aren't going to ever see in their lifetime. You need to go into the forums, find the one applicable to your situation (probably Queries) and then once you are in there you can find the button for NEW THREAD at the top left of the page.

Bob Larson
Super Moderator
Access World Forums

Today 08:21 PM
maintt

Hi all

i am creating a student attendance database for 190 students, students are allocated two hour sessions, tue to fri, and am or pm, i have created a table with the following:

StudentT

StudentID
LastName
FirstName
StartDate
ReviewDate


then i have created a query using the above and then added the dateadd expression to add a date 7 days in the future to the start date and then again 24 times ie; class1 to class 25

i then created a form using the query and the form shows all the above and when you enter a start date class 1 to 25 fills in automatically the course dates, my problem is that if a student does not attend i cannot overwrite the date field on the form, my boss wants to be able to put a new date in where the student didn't turn in and have the form recalculate the new attendance dates
any help would be appreciated

maintt

Hi all

i am creating a student attendance database for 190 students, students are allocated two hour sessions, tue to fri, and am or pm, i have created a table with the following:

StudentT

StudentID
LastName
FirstName
StartDate
ReviewDate


then i have created a query using the above and then added the dateadd expression to add a date 7 days in the future to the start date and then again 24 times ie; class1 to class 25

i then created a form using the query and the form shows all the above and when you enter a start date class 1 to 25 fills in automatically the course dates, my problem is that if a student does not attend i cannot overwrite the date field on the form, my boss wants to be able to put a new date in where the student didn't turn in and have the form recalculate the new attendance dates without having to change the query.

any help would be appreciated

maintt