Hi

Just one more question. How do I change NULL to N/A. The recipient of the report wants to see N/A where the NULLs are appearing

YOU GUYS ROCK!!!!!!

It works!

Hi R.P., here are all the tables I'm using but I'm not using all of the columns as you can tell.

Also for problem #2 change acronym 'NDA' to BL2. ...

I'm confused. I already have a document table with the exact same data in it called Dcoument Signed

So why create another document table duplicating the existing Document Signed table?

I understand but I don't have create table access only readonly. So I don't have the insert code you are looking for. I did just post a representation...

Hi Drew,

Thanks for the ideas. I just posted the tables I'm using and how the columns are shown in each table and the some data in each column. ...

Hi, Thank you for helping. I really need another pair of eyes to look at this and offer suggestions. I have tried everything, code wise to get this...

Hi, the table that holds the document information has a RevisionNO column.

The range of revisions are from 1 to 27. Some people have 1. Some have 5. ...

I would love to use a Max() function but I have 6 statements I need to use the Max() function on. When I use it on just one of...