MS Query calculation limitations

[JustATheory]

I'm using MS Query to calculate fields from one worksheet in a workbook to another. It works fine until I get around 15 fields summing into 3 fields in the results. Then it bombs, and gives me odd field names, is there memory issues or limitations that are known and should be taken into account? Any documentation you could point me to?

Thanks,
Andy

 

[SkipVought]

An example would help.

SQL, source data, current results.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[xlbo]

no known issues that I am aware of. As per Skip - code / SQL / source data example would be helpful

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[JustATheory]

I worked it out, it seems that one column I was adding in, title had to many charcters, I removed all spaces and abreviated and it worked out.

Thanks for responding, I usually include an example, but this was an odd one.

Thanks,
Andy