[gaurav200x]

Originally Posted by puneet

if you have important data , then take it professional data recovery agency... dont even try to use the disk anymore

if no imp data is there , use the drive on some other PC as a secondary drive and try to recover the files or use HDD Regenerator to repair and then try recovering ... good luck.

Can u name a couple of other softwares which does that too.... Thanks!

[gaurav200x]

Originally Posted by puneet

if you have important data , then take it professional data recovery agency... dont even try to use the disk anymore

if no imp data is there , use the drive on some other PC as a secondary drive and try to recover the files or use HDD Regenerator to repair and then try recovering ... good luck.

Hi...

yaar, i did what u asked me. Hard disk regenerator did scan for bad sectors, but it didn't restore the data. I've even tried Norton Disk Doctor, etc but nothing works. Actually, the thing is that the file system has got corrupted (as per windows) and hence, the disk seems to be inaccessible.

Now, please tell me is there any way i can retrieve the data or restore the file system/boot record.

Please reply urgently.

thnx

[Neo2000]

Gaurav,
As puneet pointed out, if it's really important data, you are better off going to a Data Recovery agency. The software available in the market is mostly directed at home users and isn't really that useful.

[neomenon]

Originally Posted by gaurav200x

Kindly help ASAP.... !!

Well, due to some voltage/power problems, i had to switch off my system abruptly. Due to this one of the partitions in my hdd (s) has got corrupted. Now, i am not sure whether the partition table alone has got corrupted, or even the data.

Please tell me how i can try and recover the data.. It is very important.

Try out a software called Badcopy pro... give it a shot... i used it recently to recover files from a corrupted pen drive... also used it tons of times to recover data from badly scratched cd's and dvd's...

Google it... Best of luck hope u r able to recover the data...

[prof_calculus]

Hi

I am rephrasing my problem:

I want to calculate the sum in a query. But the query (a field in query )column also contains text values.

I want MS access to ignore the text values in the query column and calculate the sum for numaric values.

Is there any SQL expert here to help me out?

[Krack_CAT]

dudes,

wen i transfer a file from my PC to my laptop through LAN, the transfer speed is abysmally slow... It takes 50 mins to transfer 700MB.

But wen i transfer a file from my PC to another PC on the LAN, it gets transfered in 3 mins.

I have concluded that there is a problem with my laptop...So, does ne one know how to resolve this problem??? any patches or something which i need to install.

laptop is IBM,WinXP,2GHz, 100Mbps LAN....help!!!!!!!!!!!!

[bharathraj1]

Originally Posted by prof_calculus

Hi

I am rephrasing my problem:

I want to calculate the sum in a query. But the query (a field in query )column also contains text values.

I want MS access to ignore the text values in the query column and calculate the sum for numaric values.

Is there any SQL expert here to help me out?

hi calculus,
though i have not completly understood ur query, why cant u try by giving a check for the ascii codes for alphabets A=32 and Z=57 ??:

[prof_calculus]

Originally Posted by bharathraj1

hi calculus,
though i have not completly understood ur query, why cant u try by giving a check for the ascii codes for alphabets A=32 and Z=57 ??:

Thanks for replying buddy
My problem is that my my access 'table' some entris are null. (Students who did not appear in the exam).
When I create a query I need to replace the null fields with text entry "ABSENT", in addition to necessary entries for sum etc.
Further I need to create two report - one for marksheet (showing null field as ABSENT) , and another for tabulation of all data along with summary.
In tabulation too I need to show null entries as ABSENT.
The problem is that I need to show total figures (Sums ) for every column. But the column containing text entry "ABSENT" does not accept the SUM function or shows error.
I must show absent candidates as "A" or "Abs" or "ABSENT" in my tabulation (and mark sheets as well), and I am supposed to put "SUM of column" for every column in my report.
How can it be done?
p.s.: Today I have got a suggestion (from a friend) that I may create a duplicate query for a column, one making null field as numeral zero; and other showing the same as "ABSENT". Out of the the two duplicate column I may take one for showing absent and other for making calculation.
I am goin to try it.

Any better solution ????

[funguy25]

I have a Dell laptop. The problem with it is does not switch on even after connecting the adapter.
I tried the same adapter with another laptop and it works fine.
Please throw some light on this.

Hope to hear from you.

Thanks!

[sid_rathod]

Originally Posted by prof_calculus

Thanks for replying buddy
My problem is that my my access 'table' some entris are null. (Students who did not appear in the exam).
When I create a query I need to replace the null fields with text entry "ABSENT", in addition to necessary entries for sum etc.
Further I need to create two report - one for marksheet (showing null field as ABSENT) , and another for tabulation of all data along with summary.
In tabulation too I need to show null entries as ABSENT.
The problem is that I need to show total figures (Sums ) for every column. But the column containing text entry "ABSENT" does not accept the SUM function or shows error.
I must show absent candidates as "A" or "Abs" or "ABSENT" in my tabulation (and mark sheets as well), and I am supposed to put "SUM of column" for every column in my report.
How can it be done?
p.s.: Today I have got a suggestion (from a friend) that I may create a duplicate query for a column, one making null field as numeral zero; and other showing the same as "ABSENT". Out of the the two duplicate column I may take one for showing absent and other for making calculation.
I am goin to try it.

Any better solution ????

I m not sure, but Access might be having a function like IsInteger(<The value to be tested>). If true then add, else dont.

Hope that helps.