Search results

Not yet but I will. I think that it will run but this won't help me, I think. greetings,

looks like Tonyi cracked it. Seems strange to me that there are no dates involved or numbers of items in any of your tables?

A New dawn... a new day... any new ideas?

This doesn't really help me. Thanks a million, in any case, for having a go. I'm off to work in my garden.

Maybe 2003 is a factor... But I am working in a large company and I this is not a variable that I can play with.

You're not wrong Chris, With you all the way. I have done exactly as you have described (many times) and in my setup it is based on an ODBC driver. I have done all my filtering in the access application. I need the table 'as is' in the Pivot report. In my experience all the data is normally...

pivot table I have already imported 105,000 records with no problems because it is a pivot table and not all the rows need to be displayed. I have even imported over 300,000 at one stage but then there were less columns.

join the union I find your description unclear too but i assume that you have a column for each sport in the first table and a whole list of names with an entry in the relevant column, dus the J. doe record would have an entry in three of the x columns. This is indeed a horrible format and...

I had an access table with 105,000 records and 33 columns (3 numeric). From Excel (2002) I made an ODBC link to this table in Access (2002) using microsoft query and it worked fine. I then added a numeric column and about 5,000 records and suddenly I can no longer extract the data into Excel...

Try this Maybe I am stating the obvious but do all of your data columns in the table that you are using have titles and if so do they conform to requirments? greetings,