Search results for query: *

Thanks Glenn you are a star. All sorted and all looks great. Thanks again Andrew AJD

Hi I have recently recieved a request from a colleague. I have a query pulling prices for products, eg. the product no is in column A, price in column B, conversion factor in column C. So I am pulling the product & Price via a query and need to add the conversion factor to column C. Data...

Thanks Geoff I used your formula to an extent. I used : =vlookup($A1,CUST,column()*1,FALSE) this gave me all I needed when entered in B1 and dragged across. Thanks again Geoff AJD

Hi I have a VLOOKUP that I need to use to enter info vertically =VLOOKUP($A1,cust,1,FALSE)(CUST IS A DEFINED NAME) If I fill down all is ok but I want to fill across keeping the absolute reference (A1) but allowing the lookup column to change from 1 to 2 to 3 etc. eg...

Hi I have a query that returns the following: Prod w/h cost N1141D 90 0 N1141E 90 0 N1146A 01 0.95 N1146A 90 0.95 N1146B 90 0 N1146C 01 0.6 N1146C 90 0 N1146D 90 0 N1146D 01 0 N1146E 90 0 N1146E 01 0 N1147A 01 0.13 N1147A 90 0 N1147B 90 0 N1147C 01 0.12 N1147C 90 0 N1147D 90 0 N1147D 01 0...

hi Gavona As stated in the initial question, the formula =IF($EJ14="?1","FERT" gives me a "FALSE" return. I went with the RIGHT function (GlennUK)and it works a treat. Thanks for all your help. AJD AJD

Hi I have a spread sheet where I want to return a value if a field equals a specific value. in the statement below you see if($EJ14="K1" then return "FERT". The thing is I idealy want to return "FERT" if the $EJ14 field equals anything ending in 1, I have tried adding a wildcard so that it is...

Usb devices Scanner Plotter Printer External Hard drive Graphics Tablet Keyboard Mouse I have unplugged all as suggested still the same. NB This was all done when the PC was playing up Got it started yesterday 3rd-4th try after giving up night before. This issue does not occure all the time...

Sorry for the delay No I am using a wired logitech keyboard. Just got home I will have to try the other 2 tomorrow (sorry) Ajd AJD

I realise the BIOS does not load the drivers, its just that this is the 1st PC I have had that has this issue Cannot access the bios because the keyboard is unusable until the bios has loaded. AJD AJD

Hi I have a dell latitude which is all USB no PS2 The PC boots (sometimes) but although on the post I get F2 to setup, F12 boot sequence, as the keyboard and mouse are USB the drivers do not load until after the choice exits. There have been a couple of times recently when the PC partially boots...

Hi I have a desktop running XP and a laptop running Vista. The desktop is wired to a wireless router and the laptop connects wirelessly. I have a printer that has network capability. My question is how can I connect the printer so that both computers can see and print to it? Do I need to setup...

Thanks Jimbo that done the trick. again many thanks AJD AJD

Hi I have a number of machines in a domain , but I have 8 in particular that I cannot ping. I can ping other PC's in the domain from them, but cannot ping to them from any other PC. They are showing in AD as members of the domain infact everything seems fine i.e. they can access all domain...

test AJD

I have a system running on an Oracle database which uses CLOBS and BLOBS. CLOB: Character Large object BLOB: Binary Large Object Is there any way I can access the data contained in these type of fields with Crystal. I have attempted to create a report with Crystal 8.5 & 10 and although I can...

shall try that thanks AJD

I have a pc with 2 partitions c: (5gig) & d: (60gig) with win98 on c: and XP on d:. I have a menu choice on bootup which to choose. I wish to get rid of the win 98 install and whipe the c: drive totally and be left with just the XP install on the d: drive how can I accomplish this without...

yes laptop still shuts down if on mains with battery out. I have changed processor and heatsink/fan unit and still the same. it runs fine then sort of pings and shuts down and will not re-start. if I leave it for a while it sometimes restarts it sometimes doesnt, its a kind of pot luck. Could it...

it will run on mains without battery inserted, it will run on battery whilst unplugged from the mains . Aftre running on battery for a while I plug into mains and it charges fine. It is very tempremental starting up, some times it does, sometimes it doesn't. also as said earlier after about 4-5...