Recent content by Vinod9111

Hi all, Am facing a issue while generating text output , two fields which are in number format getting populated with decimal place. I wanted the output without decimal places, to achieve that I had rounded off the field to zero but still decimal with two zeroes is being generated. Any ideas...

okay, share me the vba.

Hi Bob Am new to access, can we compact a table when there is no data The size of text file 1.7 GB though which i am trying to import.

Sure , help me with that, will it stop adding before it reaches 2 GB.

Hi Bob, I am trying to upload the txt file to a new access file

Hi Am trying to upload the text file to new access file.

Hi All, Am facing a little challenge with regard to uploading text file in a table . The number of records are large in number resulting it to surpass 2 GB in size. Any ideas how to work around to get it upload. regards Vinod Krishna.

Thanks Pat Hartman so much for providing the solutions step by step in so much detail, it worked perfectly and the output is matching with the actual figures. regards, Vinod Krishna

Hi theDBguy, Please find the SQL statements of both queries SELECT Branchmaster.[State code], Branchmaster.[District code], Branchmaster.[Block code], Sum(IIf([disb]![Segment]="weaker" And [disb]![FINAL - SLBC SEGMENT]="SC",[disb]![Sum of Loan Number of Accounts],0)) AS [Sc disb]...

Hi theDBguy, Query 1 : SCSTDisb State code - sc no disb - sc disb amt - ST no disb- ST disb amt 001 - 2 - 200 - 4 - 300 002 - 3 -300 - 6 - 250...

Thanks theDBguy,Pat Hartman, arnelgp for your replies. I have created separate queries for disbursement and outstanding , not sure how to link both to get the output of disbursement and outstanding in one report. Forgive my ignorance of access knowledge. regards Vinod Krishna

Hi theDBguy, Below is the dummy records of the table Branch master table branch code state code district code 1 02 101 2 02 104 3 04 121 4...

Hi arnelgp, SELECT Branchmaster.[State code], Sum(IIf([disb]![Segment]="weaker" And [disb]![FINAL - SLBC SEGMENT]="SC",[disb]![Sum of Loan Number of Accounts],0)) AS [Sc disb], Round(Sum(IIf([disb]![Segment]="weaker" And [disb]![FINAL - SLBC SEGMENT]="SC",[disb]![Sum of Loans Limit (In...

Hi theDbguy, The data is in lying in my vpn login and unable to copy data to local drive in order to paste on this forum due to IT restrictions. regards Vinod Krishna

Hi arnelgp, Am not using date but you are right output is incredibly more , am very naïve with regard to access not sure how to address it. I randomly checked for one branch it was 112 repetitive records been culled out. Any ideas or tips to mitigate Cartesian query. regards. Vinod Krishna