condition in some fields

[Guest]

hi all,
i have new project to do with MS Access and i was new in this application so
i have some problems plz if any one know it plz answer me
my application hold information about student and subject so i create
form,maco
but i need to caluclate student absence date then for each day they absence
i must decrease 10$ from thier account in university "both absence date and
account are fields in student table"
so plz can u tell me how to hold this condition in student tables???
i have another question about how to combine all forms and reports toghther
to make one complete application????

 

[Guest]

You should have a second table separate from student to track absence and set
a one-to-many relationship.
Do you have a separate table for transactions to their account? The
transaction table would have data like this –
StudentID TransDate Amount Reason
A453D5 2/1/06 250.00 Deposit to account
A453D5 2/15/06 -10.00 Deduct $10 from account for absence on
2/5/06
A453D5 3/1/06 -25.00 Deduct $25 from account for book
purchase
Then use a totals query to show balance.

Search on Switchboard.

 

[Guest]

You should have a second table separate from student to track absence and
set a one-to-mant relationship.
Do you have a separate table for transactions to their account?
to make one complete application????
Search on Switchboard.

 

[John Vinson]

hi all,
i have new project to do with MS Access and i was new in this application so
i have some problems plz if any one know it plz answer me
my application hold information about student and subject so i create
form,maco
but i need to caluclate student absence date then for each day they absence
i must decrease 10$ from thier account in university "both absence date and
account are fields in student table"

so plz can u tell me how to hold this condition in student tables???

You cannot.

Instead, you need TWO tables. The student table would contain only
static biographical information about the student - nothing about
attendance or absences. That information would be stored in a second
table, related one-to-many to the student table by a StudentID field.
If a student is absent six times, there would be six records for that
student in the absences table.

i have another question about how to combine all forms and reports toghther
to make one complete application????

You usually wouldn't do this. An Access Database is a container for
multiple forms, reports, queries, tables, and other objects; usually
you would have a "switchboard" or "menu" form which can be used to
select which other forms and reports the user wants to open.

John W. Vinson[MVP]