Solved it!! But just for anyone else in the UK who is wanting the same solution without spending most of the day trying to trial and error their way through, use the following code:


GROUP BY ...

Sorry, didnt take into account american readers.

UK post codes have letters and number in them and range from 5 characters to 8, it usually takes the form 1 or 2 letters, plus 2 or 3 numbers plus...

Hi i am wondering if anyone has a solution for sorting by postcode area. I wanted to be able to pick off either the First letter or first two letters and group by this.

I have figured out how to...

Hi, i am having trouble with java applets and uploading/downloading files.

The first problem i cam across was when i wanted to upload a file to BT vault which uses a java applet to do so. When...

So how would i go about setting up my own virtual machine? i would like to look at free versions. would VMWare be suitable for this?

Hi, I am fairly new to IT (i.e. graduate). I am looking to find out about virtualization and how it can be used etc... But i have no idea how it is implmentated or what use it would be?

I...

Could anybody help me with a problem i have?

I have a budget sheet and a list of incomes and expenses, and i need to be able to search a specific column and look for a certain text like general (...

Hello, many thanks for the reply i managed to find a function on the net, that was able to lock into a loop until the process was finished. which is:

Option Explicit

Private Type...

Hello, if anyone can help with this I would much appreciate it.

I am writing a macro within vba for excel, and i have successfully managed to use the shell command to call my batch file but, how...

No replies, i am just wondering if the web page needs to be sitting on a web server?

i have found out that you can edit the default error pages, but my superior is a little bit reluctant to do...

ahhh i see, they are very old computers so this could very well be the problem!

Thank you very much!

if it is just 2 laptops being connected use a crossover ethernet cable, if it more than 2 use a switch.

of course you can just use a switch for 2 computers but its a bit of a waste of money....

Try uninstalling kaspersky completely, i have had problems with previous firewalls, particulary norton which i thought was not enabled but after uninstalling worked fine. When you tried firefox did...

it logs into AD, but after fiddling for a while, i rebooted and all was fine again, it seems to be a bit weird that even logging off and on didnt do it but restarting did? i think what was happening...

have you ever had any previous firewalls installed?

hi, i have problem today whereby one of my users has logged onto his computer today but outlook, and his printers where missing inlcuding his favourites in ie7. we are currently using active...

hi, does anybody know ISA 2006 and how the web page redirect works? at our office we have isa blocking pages. so i suggested redirecting them to a html page that i knocked up so that our users would...