 |  |  |  |  |  |  |  |
how to grab data from access and manipulate it
 |
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
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
Have you connected to database and fetched the total attendance from database table ?
Share your Knowledge.
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.
((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.
Proud to be Philippine made...
|
Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: making changes to a form in vb6 project
- Next Thread: debugging
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
