Now that makes more sense. You've satisfied my curiosity and answered my question. Thank you once again.

Thank you, Mister.Magoo. This makes perfect sense. I'll make sure I start qualifying my table names from now on to help eliminate this type of issue.

However, if you were to...

Looking at Nitin's reply reminded me of a few coding things that can hinder performance (I'm basing this off my own experience).

1. If there are queries that use the AliasName...

In my opinion, adding more space will not increase performance, but you might want to consider it for future expansion of your database storage. Your processor may be operating in...

Never mind. Someone from another forum suggested that I use the JOIN function instead of my code and it works just like I want it to.

Micheal

I've come across this several times while using IIS 6 on a Windows 2003 server and the way I fixed the problem was to stop and restart IIS. If that fails, reboot...

There's a couple of ways that come to my mind in order to accomplish this:

1. Place the date value in the header of the report where it repeats with each page.

or

2....