Search results

I think... I'm not very good in this either. I just know i had this once when i tried to transform... And that number behind the error was exact the same as the numbers of columns i tried to make. max number of columns is 255 i think.

You tried to make 454 columns but you only can make 255 columns... I think.

It doesn't do what i want. It gives me the number of different FarbeBC. In this case that would be 3. Maybe to clear things up a bit DateEVT | FarbeBC 13/03/2007 06:14:09 | -M7X 13/03/2007 06:16:12 | -M7X 13/03/2007 06:17:12 | -92U ---> This is 1 change 13/03/2007 06:18:35 | -92U...

Hi, I need to count how many times FarbeBC changed in value. I don't need how many different values. That would be 4. But it only changed 3 times. I managed to do this in excel. But can can't find out how to do this in access. Any help from you guys? I've Access 2000 with an ODBC connection...