What is the structure of the tally table "Numbers" listed in the example?

Nice work.

David

Wow, after looking at the results of your modification of Mark's code. I believe this is exactly what is needed. the 15 codes are not unmanagable as this could be...

There are 15 write off codes and they are defined in a table. One requires a comment because it is OTHER. So they are pretty static.

thanks.

Thanks for the reply. The main purpose of the query is to find accounts that have a write_off amount. The application will not allow the users to write off an...

As fate would have it I asked about the multiple write_off_codes, and there can be several. I ran your code on the tables and got exactly what I was...

Thanks. Life is just too short to be irritated all the time. 😛

:angry:I can feel the pain and I also suffer with it.

I believe what we are trying to discover is how do we turn off the dashed line in query results....

You might be able to read it into a string and and pass it to the XML Notepad listed in the link below.

I currently save the strings into a file...

This script is great:D:D I'm beside myself with joy

Below is my first attempt at posting here or anywhere on the net so be kind.

I've converted the vb code to...