Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Add a number to one duplicate record in SQL
Good afternoon, I have an issue where a client updated a table combining two companies of data. Now they have about 400 records that are duplicated. Meaning, for those 400 records, there are 2 records sharing the same number for 200 pairs of employees now. I need to find an easy way to update...- esdad71
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
Updating Foxpro tables with Excel files
I am trying to update payroll information for employees in a foxpro table. I have an excel file that contains the new information but I am having trouble updating it with Access. Each file contains unique fields for the employee number,the company and the code to update. Each time I try it it...- esdad71
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Use Select Expert in main report within subreports
Good evening. This is my issue. I am running a Crystal v10 report against a foxpro table and I am using 1 database within the main report and another database to pull specific information into 3 separate sub reports within the main report. I have created the shared variables for the totals...- esdad71
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 2 Data Access
