Database Development RSS

NAVIGATION
CATEGORIES
REFERRENCE
LINKS
  • Z-Score Of a marks list

    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...

    1 answers | 335 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • zipping .mdf givz sharing violation

    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 ?...

    1 answers | 165 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • Zipping (NOT Compacting) an mdb

    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!...

    0 answers | 278 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • ZipCodes

    Any 1 has a quick algorithm to validate zipcodesfrom database?...

    0 answers | 67 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • zipcode 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...

    5 answers | 616 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • Zip Code Table

    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...

    0 answers | 199 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • zip code directory

    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...

    1 answers | 191 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • Zero value cannot store in database

    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?...

    2 answers | 212 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • Zero Length string problem

    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...

    5 answers | 768 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • Zero Length Date Fields in Databases

    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...

    1 answers | 446 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • Zero Date Differs.

    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...

    0 answers | 363 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • Yukon Beta MS SQL Server primary change?

    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...

    3 answers | 976 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • Your Opinions, please!

    Should I choose Data Report or Crystal Reports for my applications (local and remote) and why?Thanks!:confused:...

    3 answers | 126 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • you need permission to view its data.

    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...

    1 answers | 1778 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

  • You know the best way?

    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...

    3 answers | 433 bytes | related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

QUESTION ON "Database Development"
WWW.PROGRAMMERBASE.COM