That's the problem....this area is for upper level managers of the company and they want to see a lot of different data fields without having to click here and there.  So...

Hey Noel,

I'm open to any suggestions that anyone has and instead of not liking it....i'm actually very happy and glad that you all have taken the time out to read...

Thank alot for all your help remi.  I think your solution might be the best option....using a perm table and inserting data from the view to the table and they'll...

Let me give you an example which might give you an idea of how the user is going to access the data:

Based on there rights...each user will see a different...

I'm sorry Remi....i guess i'm not using the right words here.  What i posted previously was a view that pulls from about 50 other views since all the data is...

Here's the query...it's pretty big and the reason i have such a long query is because our website is for project managers to track projects from start to finish so...