Search results

I am running simple query on a linked sharepoint list. The field I am querying is a sharepoint choice field. The query returns the choices slected with special characters in front of it. How can I remove these characters? Example: ;#Project Tracker Entry Created;# I'm attempting to set a...

Well the combo box pulls from the 1st table of active projects. Anytime a change is made to the project to any field, a whole new record is created in the history table (the 2nd table) "trial audit". So when the project isn't active, I don't want that project to show up in the combo box...

Hello, I have a project tracking database. Project Managers update their projects on the table via a form. Once the project is closed I have a button on the form to delete the project from the "active project table". I already have an append query that brings the record to the history...

Hello. I have 2 tables PT and PT History. Project Name is the primary key on the PT table and an autonumber ID is the primary key on the PT History Table. Users update records in the PT table via form. When they complet their update they click a save button which saves the record and runs...

Project Manager Table ID First name Last Name Full Name Manager Name Phone Number Project Assignment Table ID Project Manager Project Name Project Number Project Type PM Role PM Role Description Table ID Description Numeric Value Project Table Project Name Project Number Project Status RAG...

I do have the tables set in that fasion. I have a project manager table listing all the mangers names, info etc. I then have a table where the project assignements are made including their role. I then have a table with the role ID # and their descriptions, exactly how you described above...

SELECT [Q_Active Project List].[Status Change], [Q_Active Project List].Proj_Type, [Q_Active Project List].Project_Size, [Q_Active Project List].Primary_PM, [Q_Active Project List].RAG_Status, [Q_Active Project List].Target_Imp_Date, [Q_Active ProjectList].Adj_Target_Date, [Q_Active Project...

Hello, I am developing a project tracking database for my department. I am creating an active list of the projects and need to show the project manager for each project. There are a few titles the project manager can be. I've assigned an ID to each of the those titles. Program Manager = 1...