HI Adezii,
is there any possible way that i can fix this using ACCESS DATA BASE instead of excel VBA...
i have data around 2lakhs rows if i perform this operation in excel using VBA it takes time. so i want to fix this requirement in access data base.
snanjund
Last Activity: May 22 '17, 06:25 PM
Joined: Sep 28 '16
Location:
-
HI Orally,
i want to perform this in MS access database..
could you help help how can i resolve this.
waiting for you feedback many thanksLeave a comment:
-
HI ADezii,
Many thanks for your response..
can we do same in MS access database, as i have around 2+ lakhs data line items.. and i am also performing few calculation in access database, so that this will help me if i loop of cells in Access database.
waiting for your feedback :)Leave a comment:
-
Loop through the cell and give the anser
PLEASE HELP ME ON BELOW QUERY
I HAVE 5 COLUMNS...
I HAVE SORTED THE DATA FROM SMALLEST TO HIGHEST(code column)...
NOW I WANT TO COMPARE SUBCATEGORY WHETHER 1ST AND 2 ROW DATA IS ARE SAME, IF YES THEN I SHOULD GET RESULT AS TRUE
FOR EXAMPLE GIVEN BELOW
CODE--NAME--DATE--CATEGORY--SUBCATEGORY--RESULT
1------A----2015---HC---------HCP1--------TRUE
1------AA---2016---HC---------HCP1--------FALSE
...
No activity results to display
Leave a comment: