ALL ARE ONLY PART OF THE DATA. I'm intending to import the excel file into access. then compare the 2 tables and get the common students between modules. Example: paper 1 (S/N 1) : EG1832 paper 2 (S/N 2) : EG1833, EG1952, EG1903 And StudentID:112673P & 119283H is involed in EG1832 & EG1952 then, output: conflictive paper No.of students AdminNo paper1 : paper2 2 112673P, 119283H
How can i go about doing this? im really stuck. any help will be appreciated
Any help will be greatly appreciated. Thanks in advance!
Perhaps that's a database question. you can post the problem on sql server forum. and here some suggestion about your question:
the code/pseudocode is something like
----------- dim rs as recordset
set rs = currentdb.openrecordset "mytable"
while not rs.eof {process the record} rs.movenext wend
rs.close -------------------------- when you are in a record, you can examine fields with thisvalue = rs!myfield
to set/update fields you need to add
rs.edit 'to edit it then you can say rs!myfield = "whatever" rs.update 'to save the edit
various other commands exist for recordsets
Hope that's helpful.
vbprogramaccessvisualbasic
Please mark the replies as answers if they help or unmark if not.
Feedback to us
fangling
Member
1 Points
7 Posts
Looping through access datatables and compare values to get conflicting data
Jul 16, 2013 07:43 AM|fangling|LINK
i have an excel which i transferred to access database containing the following:
Another table in access containing the following:
ALL ARE ONLY PART OF THE DATA.
I'm intending to import the excel file into access.
then compare the 2 tables and get the common students between modules.
Example:
paper 1 (S/N 1) : EG1832
paper 2 (S/N 2) : EG1833, EG1952, EG1903
And StudentID:112673P & 119283H is involed in EG1832 & EG1952
then, output:
conflictive paper No.of students AdminNo
paper1 : paper2 2 112673P, 119283H
How can i go about doing this? im really stuck. any help will be appreciated
Any help will be greatly appreciated. Thanks in advance!
vb program access visualbasic
Chunyan Yu -...
Contributor
6513 Points
604 Posts
Re: Looping through access datatables and compare values to get conflicting data
Jul 19, 2013 04:01 AM|Chunyan Yu - MSFT|LINK
Hi,
Thank you for your question. I am currently looking into this issue and will give you an update as soon as possible.
Thanks for the understanding.
vb program access visualbasic
Feedback to us
Chunyan Yu -...
Contributor
6513 Points
604 Posts
Re: Looping through access datatables and compare values to get conflicting data
Jul 30, 2013 10:21 PM|Chunyan Yu - MSFT|LINK
Hi,
Perhaps that's a database question. you can post the problem on sql server forum. and here some suggestion about your question:
the code/pseudocode is something like ----------- dim rs as recordset set rs = currentdb.openrecordset "mytable" while not rs.eof {process the record} rs.movenext wend rs.close -------------------------- when you are in a record, you can examine fields with thisvalue = rs!myfield to set/update fields you need to add rs.edit 'to edit it then you can say rs!myfield = "whatever" rs.update 'to save the edit various other commands exist for recordsetsHope that's helpful.
vb program access visualbasic
Feedback to us