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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. esdad71

    Add a number to one duplicate record in SQL

    gmmastros - you are the man! That is exactly what I was needing. I had something close but it would not finish. Have a good one! [2thumbsup]
  2. esdad71

    Add a number to one duplicate record in SQL

    No it is just two tables. I checked after I was told about this. The other table can be deleted and recreated/reimported but I would like to find an easy way for this table as they have edited lots of employee data since the original import last month. Thanks for the heads up!
  3. esdad71

    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...
  4. esdad71

    Updating Foxpro tables with Excel files

    I am using ACCESS to update a Foxpro table with an Excel file so I would have thought I would put it in an Access forum. I am attempting to create an UPDATE statement and wanted to know if anyone had done a Foxpro to Excel update with Access and if there was any issue. I figured it out...
  5. esdad71

    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...
  6. esdad71

    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...
  7. esdad71

    I want to pass a formula result to a stored procedure

    Good afternoon, I am simply attempting to export to a csv file in Crystal v10. I am accessing one VFP OLEDB database in the main report and another in the sub report where I am drawing simple totals. Problem is that when i export, it is not including the sub report fields. I am not sure if I...

Part and Inventory Search

Back
Top