You can use the following query:

SELECT * FROM [Reports Table] in "F:npathtpreport.mdb"

Substitute the location of your npath folder.

Now you can make changes to any record/field in the table, but take care, and make sure you have a backup and a clear idea of what you are going to do.

Last update: 09:15 PM Monday, May 15, 2006

• How can I add an automatic deduction record for every employee record?
• How to show tables in an external database
• How to create a currency rounded overtime billrate using the regular bill rate - SQL code
• Parsing the Last and First Names from the Applicants.LastNameFirst field
• Query to show changes or deletions from the CheckHistory table that were performed using the Edit Applicant Check History option.