Recent content by akashneelh

Please help me guys ... I am sure you have brilliant ideas about it.

HI, I have a ms access table with two fields...tablename is ..."Addresses".. Field1:= Employee_mail_id Field2:= Leave_balance What I need to do is that,I need to send individual mail (in Bulk) two each employee intimating their leave balances. Is it possible to do it in vb .I want it to...

Thnx its a brilliant condition applied ..... Bingo...you have done this...

pls help me guys

Re: Get the next higher number in a access query pls help me guys

Get the next higher number in a access query Hi, I have a data where I want to create a query fulfilling the below conditions. Suppose I have two table: Table 1 and Table 2 in an access. Table1 contains two fields ACCOUNTNUMBER,MaxOfMRP Table 2 contains only MRP field. Now If I want to get...

Hi, I have a data where I want to create a query fulfilling the below conditions. Suppose I have two table: Table 1 and Table 2. If a value ex.98 (Table1) ,it should pick up my second higher value 103 from my table 2. As 103 is the next higher value of 98 . Please see the data Table1...

Hi Actually the was not in this format ..I am resending my question

Hi, I have a data where I want to create a query fulfilling the below conditions. Suppose I have two table: Table 1 and Table 2 If a value ex.98 (Table1) matches with the value with 98(Table 2),it should pick up my second higher value 103. suppose 103 is the next high value of 98 . Please see...

Hi , First of all make a group by of your Fname field to make unique. For the blank fields U can try Trim function. Trim (" Fname ") would return "" without any space. If still the problem persists,please provide some sample data to check.

I have succeeded to make the macro procedure.... Here: Table1 contains duplicate values in mobileno field. Firstly I created a New table with a primary key.. Query 1. Create table Table2 ( mobileno double primary key, status text ) Query2. INSERT INTO Table2 SELECT Table1.* FROM Table1...

Hi, This process is fantastic.But it is a manual method .I want to implement this process in a macro.It is possible to make a copy of the table and set primary key in the Macro...Please reply....

Hi, I have a data as attached below, I want to delete the the duplicates keeping one data from the duplicates value.Is is possible using qury criteria in MSaccess query. Please help Guys ORIGINAL DATA REQUIRED DATA abc abc abc ccc ccc aaa ccc ddd...

Hi, Please suggest how to change saved import path option daily . Suppose, my current import path is D:\Assam\BI_Dump_ASM\2012\Nov'12\1-17-2013\DailyActBalance.csv I need to automate it daily like D:\Assam\BI_Dump_ASM\2012\Nov'12\1-18-2013\DailyActBalance.csv...