plantigrade

Hi Kasper,yes, but it it would be complicated. I think you need to convert the number to an integer, subtract the integer from the original number, compare the result of that to 0.5 to decide what value to add to the integer to get your 'rounded to nearest 0.5' value that I think you're aiming for. SQL is really meant for querying databases, but it can produce 'calculated fields', so it could do what you want. It might be simpler with PHP.Plantigrade

If your website is hosted on an Apache server (that's most hosts) you can set a password by creating a text file called .htaccess, which protects all the files in the directory. Win machines won't do this as a filename, so you have to save it as htaccess.txt or something, upload it to the directory you want to password protect, then change the name. In the file you just writeusername:(encrypted password)and make sure you save it as a simple ascii file.There are sites that will tell you what the encryption of your password should be, eg http://www.tools.dynamicdrive.com/password/ I don't have a clue about MS-Access. Someone else will have to help with that bit!Plantigrade

Hi MiltonUsually in windows you have to start MySQL from the command line using a program called mysqld, so the command line is something like:C:>\path-to-mysql\mysqldwhich gets you a message that MySQL is up and running (or if you're like me, a bunch of error messages :-) )There's a good description of this at hereOnce your MySQL is up and running I'd suggest using a graphical front-end to set up your first database. Doing it like that is less frustrating than trying to do it from the command line, cos you can actually see what's happening. Mysql-front is the best I've tried - it costs, but you get a couple of weeks free, which should be enough to get a feel for the database. Sqlyog is free, but not quite as user-friendly. Hope this helps. Plantigrade

But don't let all this complication and good advice put you off! There are free hosting and domains to find if you look, free html editors and ftp programs to download, free tuition from sites like W3 Schools. Don't forget - the greatest website started with a single 'Hello World'.Plantigrade

Mmm. Shame, really. Something easier than php would certainly be welcome! From your post referring to show., default. and add.asp it sounds as though it's well adapted to database queries. On the other hand, php is free so it must be terrific value for money! Plantigrade

Is ASP platform-independant then, Aspnetguy? I thought it was limited to servers running a Microsoft OS, so won't work on the usual 'nix-apache setup. Plantigrade

Stu Nicholls is a living god.IMHO.plantigrade