hello,
Im doing a system to calculate student attendance to class. Now i'm having problems to grab a data from Access, use it as a value in VB calculation. Then, how to send the answer of the calculation to another [FieldName] as an updated data in Access.
the formula of calculation is:
% attendance = [ (total attendance/28) x 100% ]
for your information,
total attendance is the data to be grabbed from Access
Your kindly respond is most appreciated.TQ
Jump to PostHave you connected to database and fetched the total attendance from database table ?
Have you connected to database and fetched the total attendance from database table ?
You must get the total of the number of times the student attended the class. Which is from the database. Next, after getting the Total, you can now use your formula:
((total attendance/total class days) x 100%
Now, the only problem you have are:
1. How are you gonna get the Total Attendance?
2. How are you gonna save total attendance on the database?
go here for connection strings.
Correct me if im wrong with the analysis.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.