


I want to get the z-Score for each record of a Marks List.Z-Score = ([Student Marks]-[average Of Subject Marks])/([standard Deviation Of marks list])In Excel command=(A1-Avg(A$1:A$50))/STDev(A$1:A$50)Note: "A1"-current student marks "A$1:A$50"-Marks ListBut how can I change it to Sql for ms-Acce...
whenenver I try 2 zip up my db(.mdf) file , it givz an error. I can't even copy it to another folder.Do I uncheck the archive in the file properties ?...
What could cause an mdb to have 0% compression when zipped. I import all the tables into a new mdb and get 90% compression when zipped. THe following thread might describe better:http://www.vbforums.com/showthread.php?s=&threadid=195699THanks for any help!...
Any 1 has a quick algorithm to validate zipcodesfrom database?...
I'm building a store locator type of application and need to find a database which contains all zipcodes in the US along with the associated longitude and latitude information (needed to calculate distances). Does anyone know where I might be able to purchase the data that can then be co...
Does anyone have an Access table with City, State and Zip Codes that I could bum off ya? Need one to include in my donor mailing list program for my church.Thanks,Rev. Michael L. Burns...
Where can I obtain, a listing of city/town, state and Zip codes for the US?Is it available for download and in an excel format or a dbase format?Thank youLeonard...
I have field name "Category" and its is number data type. Why I cannot store zero value in the table, I want to store the value like this 0001 but it store the value in the "category" field as '1' .Why?...
HelloI have an app that takes info from a word table and puts it into a DB. I have a problem that is creating a high stress environment for me. 1. I have a field that the data type is date, with required = no. The problem comes if the word table field is blank. This gives me a "" and I get a typ...
Can any one tell me how to save 'Nothing' to a Date field in a recordset.Senario;A date has been saved to a Date Field, thus changing the field from Null. The date is then not needed and deleted from the corresponding textbox object bound to the field. If I leave the textbox empty I ge...
I am using VB6 accessing as SQL Server 2000 Database.In my VB app I convert my dates to longs and store themin the SQL Server DB.I thas now come to attention that the zero date in VB6 is 30/12/1899, but in SQL Server 2000 it is 01/01/1900.Is there a way to set the zero date in VB6 so that it mat...
Hi people, I noticed the followin news messages on WinInformant:Yukon Beta Launch Q1 2003 (http://www.wininformant.com/Articles/Index.cfm?ArticleID=27529) http://www.wininformant.com/inc/images/WinInfo/sql_server_logo_sm.gif A quote from this new Message:Microsoft will deliver Yukon Beta 1 to ju...
Should I choose Data Report or Crystal Reports for my applications (local and remote) and why?Thanks!:confused:...
Hello,I'm getting this error message:Error Type:Microsoft JET Database Engine (0x80004005)The Microsoft Jet database engine cannot open the file 'c:\inetpub\wwwroot\emd\password.mdb'. It is already opened exclusively by another user, or you need permission to view its data./emd/Pr...
what is the best way to store records which i'll be not using oftenly?example i'll be transacting for this month so in my table only records of this month should be there after this month i want to store the datas in different place, so that for the next month there are only records th...
