> sorry ops it is access not excel sorry about that so anyone know what
> wrong with it??
>
> rgds,
Yes. As I mentioned to you elsewhere, Excel is not a database, and that is
the problem. You are using a hammer and you need a screwdriver. You are
essentially saying, "I've been using a hammer to put these screws in, but
the hammer is now bending some screws. Can someone tell me how to fix the
hammer?"