Uggg Help with Reserved error -1038 - not Access 97

[mallegirl]

I have been using a bit of great code and SQL I found on this site and it has worked fantastic but all of a sudden i am getting this error message. " Reserved error (-1038): there is no message for this error." All i can find about the error is that it has to do with access 97 but i have 2002 and never had this db on a computer with access 97. I think i might go crazy if i can get this to work. I am new to this whole site but here is the URL to the original post i was working from.

[mallegirl]

Combining Multiple Rows of one Field into One Result

[Dököll]

" Reserved error (-1038): there is no message for this error." All i can find about the error is that it has to do with access 97....

Glad to hear we have helped you solve some issues, mallegirl... please continue paying us a visit now and then.

I am not sure what may be happening. I will however send you over to our gurus in VBA to see what could be salvaged for ya.

Sorry for your troubles:-)

[mallegirl]

thanks

I appreciate you taking the time to respond. I actually figured out how to make it work.

The solution uses Max(concat(grou p, item) but for some reason that wont work for me. I changed it to last(concat(gro up, item)) and now it is working again.

[NeoPa]

Check out the linked thread again (You should be subscribed already).

I have highlighted two posts which indicated that the OP had a similar problem to yours, as well as finding the same "solution".

[vissas]

Thanks

Hi,

I cut and paste the code and works perfectely fine (ofcourse I have to use last and not max).

Really appereciate the solution.

Thanks!!!!

[NeoPa]

Thanks for letting us know :)

Another related link - direct to the solution - is Combining Rows-Opposite of Union.