Very good. Thank you.

Thank you.

Because I want to add address. phone #, etc, and I know there's a way to do this I just can't figure it out.

Thank you.

Nice to know. Thanks.

Are you talking about the price to pay for Crystal Enterprise itself or is there a fee or license that has to be paid for each user?

And Crystal you need to get a license for each client? I need to get the cobwebs out.

Which versions of SQL Server have the reporting service, which ones do not?

I've never heard of having to license a report you developed yourself.

Thank you.

Develop reports. Doesn't SQL Server have a report developing feature? Visual Basic does not.

I thought sql server's reporting services would make this a good idea.

Backup because it doesn't copy, right? Do you think it would ever make any sense to do this?

Thank you. So for example you could not have a setup disk with a visual basic program and a sql server database the way you can have a setup...

Kathi,

You mean:

select

t1.subscrno, t1.Subaddeffdate, t2.Delhouseno, t2.Delstreetnam, t4.Subrouteeffdate, t4.routeno

from

(select x1.Subscrno, max(x1.Subaddeffdate)...

Going with SQLserver, suppose you have 500,000 records in each of the 2 tables.  I need to allow the user to generate a report.  To...