Search results for query: *

Hi, I have a machine running windows XP Pro. The machine is hooked up to the internet via a cable modem attached via an ethernet connection. The machine is leased a valid ip address and you can ping url's without any problems from the command prompt. Internet explorer and MSN Messenger however...

Hi, I have a machine running windows ME. The soundcard is installed OK and there are no conflicts in device manager. When you look in "Sounds and Multimedia" under audio, the preferred device shows "no playback devices" and it is greyed out. There is no sound from the card at all, if you try...

Hi, I have a transactions table in my database which stores info on customer purchases e.g when they bought, what they bought, how much they spent etc. The customers are identified by a cust_id field and the date field is called order_date. Each record records one instance of a purchase i.e if...

Hi, I use some software to identify duplicate records based on inital and surname for people who live at the same address. There is a field in the database called dup_code which stores the identifying value e.g if two records were identified as duplicates they would both be given a dup code of...

Hi, I'm trying to run an external program from within a stored procedure using xp_cmdshell. The actual software I want to run is some address cleaning software which does not require any user input to run. For testing purposes I have been trying to launch the windows calculator from within...

Hi, I have a customer table which stores customer info such as name, address, etc. The data is taken from a till system and for some unknown reason there is a field full of numbers contained within the address data, there are no letters in the field only numbers. There are a total of 7 address...

Hi, I have a machine running windows xp home edition. I have had to do a repair install, and the machine is now running ok. BUT when you look in device manager all hardware is ok except the display adapter. The actual group does not exist yet alone the actual adapter. I have tried installing a...

Hi I have a table which stores forenames and surnames in seperate columns. I need to change the font case to Title Case e.g. Paul Rowling as many of the names are stored in upper or lowercase. How can I do this using an sql statement?? Cheers Paul

Hi, Please excuse me if this is a stupidly easy question, but I have only been using quark since this morning!! I'm using quarkexpress V5 and I have an image which I want to print two copies of on a single page. At the moment there is just the single postcard image in the document, but I want...

Hi, I have a machine running Windows XP Home Edition. I activated the OS over the internet. On completion I received a message stating that product activation had completed successfully. I later rebooted my pc, when I did I still receive the message stating that I have 3 days left to...

Hi, I have a table which stores address data with one of the fields being a postcode field(or zip code for those of you who are american). What I want to do is to pull out customers by particular postcode. The following is a list of postcodes that I want to select customers by, but they are...

Hi, I have a table full of customer names. The name is stored in a single column and is in the following format: Paul Rowling Susan Smith etc.......... What I want to do is to strip out the first part of the name and store this in a Forename column, and then strip out the second part of the...

Hi, I've got a query which totals a customers spending from the transactions table and then updates a field in the client table with the total value previously calculated. The query looks like this: update CLIENT c1 SET c1.field_1 = (select sum(tr.credit) from CLIENT c2 inner join transactions...

Hi, I need to write an sql query which will find the top n spenders in a table, based on the total the customers have spent which I have calculated already. Is there some form of "Clause" to enable me to do this? In JET SQL there is a command called top but it doesn't look ike this...

Hi, I'm going to be moving an access database into Interbase, and I am by no means any sort of programmer. So, I'm looking for some form of graphical query builder to produce the SQL for me (similar to how access does). I have had a look at a piece of software called EMS IB Manager which has...

Hi, Is it possible to change text from Upper case to Title case? I can see how you can change from lower to upper and upper to lower, but I can't find a function which will allow me to change to title case. There is more than one word in the text that I want to change. I also want to be able...

Hi, I want to be able to replace spaces in a persons name with commas eg Mr Paul Rowling would become Mr,Paul,Rowling. I know that there is a function called replace which should do the job, but I'm unsure how to use it and wether it can be done from within a query? I'm not a programmer by any...

Hi, Say I've got a person's name in a single field which is in the following format: Mr A B Cowlett How do I seperate the "Mr" into a title field, the "A" into a Forename field, the "B" into a Middle Name field, and the "Cowlett into a Surname Field?? Any...

Hi, I have been sent some customer information which I want to incorporate into a larger database. The problem that I have is that the customer name (in its entirety) is stored in a single field and I want to be able to break it down into Title, Forename, Surname etc. Also some of the names...

Hi, I have a main transaction table which is related to a department table via a department_id field. The department table is then related to a workgroup table via a group_id field and then the workgroup table is related to a business table via a business_id. This then enables you to search...