I have a table called Remarks with 2 fields: Remarks_text (data type--memo) and proj_num (data type-text) which i get from an external source. I import the Remarks table via ODBC and have no control over its structure. So i can't add new fields to it. The table currently has 3800 records.
The field Remarks_text is used as a log. Whenever someone writes a remark, the name and time gets stamped automatically.
I also have a table called Employees.
I would like to have a form or report that extracts the remarks_text if they are written by someone in the Employees table.
For example, here is ONE record from my table:
--proj_num = 279
--remarks_text =
Mar 26 2003 4:13PM - John Victoro [square] The following project has been received in the office on 03/22/03.[square] Mar 26 2003 3:40PM - Kerry Akeve [square] Specs was shipped today (03/26) [square]
Mar 26 2003 8:54AM - Peter Bruce [square] System is connected and under test. We are running errors on the project. Await arrival of other equipment.[square] Mar 26 2003 8:19AM - Kerry Akeve [square] Revision 2 released
The word [square] is actually a little square which signifies a link break.
In the Employees table, i have John Victoro and Kerry Akeve. So for this record, i would like the form or report to only their remarks:
Mar 26 2003 4:13PM - John Victoro [square] The following project has been received in the office on 03/22/03.[square] Mar 26 2003 3:40PM - Kerry Akeve [square] Specs was shipped today (03/26)[square]
Mar 26 2003 8:19AM - Kerry Akeve [square]Revision 2 released
The raw data is entered via a website on our company's intranet. To get to the website, you have to log in with a name and password. Then, if you want to enter a remark for a project, you navigate to the correct project_id record, click on the Remarks tab and hit 'edit'.
The time/date/employee stamp is automatically entered as part of that website. (i didn't create the website). Therefore, the format (3 letter month, 2 digit day, 4 digit year, space, time, space, dash, space, name) will always be consistent and the names will always be entered consistently.
Does anyone have any ideas how to do this?
Thanks,
