Search results for query: *

I know this will be easy for most of you but i cant seem to get my head round it this morning, I have column A filled with numbers and column C with numbers in it. I want to compare A with C and if it finds a match in the range fill column B with the contents of column D. Thanks for your help

Hi Does anyone know away of tracing which extension an external call was picked up at ? think we have someone in the office hanging up on customers but not sure who! Thanks Matt

Hi i'm looking for a bit of help with this. We have a remote site connected to us via a router to router VPN connection, i can ping the DC from the remote site but is there an easy way to make sure it tries to log on to the DC when the user logs in ?

Hi We have an Office Serv 7200 and i'm trying to find a way to make several extenstion Internal only ie. Can't dial out of the building. I've been looking through the Manager but can't see anything. Is it possiable ? Thanks Matt

Afternoon all, This morning i have come into the office and 2 pcs on the first floor have no network connection, I checked all the cables back to the switch with a network tester and there all showing fine, I plugged another PC into the two ports that appear not to be working and it worked...

Hi I'm trying to get a formula to work but cant seem to get my head round it this morning. I have a cell E14 with a list in it, Gold, Silver, Bronze I want cell E15 to look at it and which ever value is selected use a folrmula for it. Something like this...

Hi We have a remote warehouse that is connected to us Via router to router VPN, I've been looking at ways of letting it logon to the Domain over the VPN and have been told that a logon script should do the trick but can't find any information anywhere of how to do it, Could someone point me in...

Hi Not sure if i'm posting this in the right section but here we go. My server 2K server running SQL 2K and our Intranet was dying so i cloned the disk and moved it to a new machine. It came up fine and the Intranet which gets its stats from the SQL worked fine apart from its showing dates as...

We have exchange 5.5 and the directors have just got PDAs and want to pick up their email on them. Is this possible from 5.5 and if so can you direct me to any setup guide as i can't seem to find any info. Thanks Matt

Hi We have a site to site VPN using Netgear routers, Is there a way of directing the remote site XP Pro machines to the Domain controller for logons etc. ? Thanks Matt

Here is a select query i have, SELECT Tame_cust.Rep_Name, sum (Case Tame_cust.hlp_benefits When 'No' Then 1 Else 0 End) As [ATP Leads], sum (Case Tame_cust.hlp_benefits When 'Child Tax Credit (less than £14200pa)' Then 1 When 'ATT Allowance' Then 1 When 'Disability living Allowance' Then 1...

Hi Not sure if this is possiable but i want to run a query and then dump the results into the main body of an email. I know you can do it with an attachment but i'd prefer not to do it that way. Thanks Matt

Not sure if i'm posting in the right forum but i've been asked to setup for screens around our building displaying the same information from a single PC. Has anyone set this up that can give me a few pointers on whats the best kit to use. Thanks Matt

Hi we have a SBS 2003 Standard server installed and from what i've seen i belive this comes with Exchange 2003 but i can't find anywhere to install it. Does anyone have any ideas. Thanks Matt

Hi I have a SQL 2000 table with around 50,000 records, I have been asked if we can add a Auto Number to any new records added. I have added a int Data Type column which works fine but i have now been told that it needs to be 8 digits so starting at 00000001. Not sure how to do this if anyone...

I think this is quite straight forward but i still can't figure it out. the first thing i want to do is copy everything before the first space from Field1 to Field2 and then everything before the first , from field1 to field3 ie Field1 The Dogs, Nuts Field2 The Field3 The Dogs

i have this code that i've compiled in SQL and it works fine. But i have now been told the webpage its been written for is using an Access db and not SQL. Can someone give me some pointers on what code i need to change to get it working with Access & Frontpage. Thanks Select a.Team...

A friend has asked me if i can automate his Cricket league table, I've had a go but am not familiar with running Union querys. I've got this far upto now. SELECT Team_list.Team AS Team, Count(LCL.home_team)AS [HP], Sum(Case LCL.home_points When '5' Then 1 Else 0 END)AS [HW 5], Sum(Case...

We have a dialler connected to our Option 11 using a QSig link. At the moment if i dial 3999 it connects me to channel 21 or channel 22 (Which every is free) on the QSig link. I now need to change this to connect to Channel 27. Is this something quite simple that i can do myself ? and can...

I looking for some help on the following things.. Does anyone have a templete for the keys on the M3820 phones that i could have ? Also is there anyway to get Meridian mail to kick in on busy instead of just when my phones on forward ? Thanks Matt