Recent content by nirapreet

The field in question is of type text. What's happening is that the in one field the value being uploaded is Alphanumeric. The rows whcih are numeric value for this field , works fine & are being uploade corect in this text field. But when the value is alphabetical, it causess the above said...

The upload is missing some fields and the error table says type conversion err Thanks Nira

Hi all, I am trying to upload a .csv file in a table using the tRansfertext method in vba. I have atext field having alphanumeric values. The upload is excluding the some values and generating a new error table. How do I get rid of this error. Do I have to use a specification name. I have new...

It worked... You are a gem..!! It worked..!! Thanks for your help..!! Nira

Hello all, I am trying to generate a qyery based on a table. My table has fields as below FnCode ErrCode ErrDesc and effective date The logic behind it is, The data is uploaded in the table on any date for diff fnCodes. My data is like FnCode ErrCode ErrDesc and effective date aaa err2...

I will try that..!! Thanks once again for your time.. Nira

Re: query Thanks for your help John, Actually I was able to get the solution usin the Top1 pred and Not IN. But I am stuck on some other point now. What I was trying to do is that as my table can have duplicate row for different date ie as below, FnCode ErrCode ErrDesc and effective date aaa...

Thanks John, Great..That worked..!! I sthere also a way where I can pick up all the records with the date as 2nd last date ie if the data was uploaded on date 1 and then on date 2, I should be able to pick all the records from date 1. Thanks for your help. nirapreet

Hi I am trying to generate a report based on a table. My table has fields as below FnCode ErrCode ErrDesc and effective date The logic behind it is, The data is uploaded in the table on any date. This data tell the errors for particular fund on the date it was uploaded. Now if on a particular...

Hello All, Got stuck with a query ...Please help I have some fields in my table as I want to genearate a query on a table which lists similar records for different date. The fields are like The records in the table are like Code,Name, fund, status, effective date 001,XYZ,BINN,MM...

Hi, I am new to Access reports and I am facing problem to create a new report. I just have to create report where the criteria is set from the a combobox on a form. Depending on the value in this form I want to set the criteria. The report gives the desired result when I open it . But when I...