Search results

  1. C

    update table from select

    I figured out my problem. Access was complaining because I was not telling it where the field was coming from. Here is the correct query. SELECT * FROM edi_out A WHERE NOT EXISTS (SELECT * FROM edi_out_new_data_distinct WHERE edi_out.f10=edi_out_new_data_distinct.ctrl_num); -Chris
  2. C

    update table from select

    spikepl, I took your advice and looked up some EXISTS examples. When I run the query a message box pops up asking me to enter parameter value. I just want to run the query not have this box pop up. Any idea on how to bypass this box and just execute the query? Below is my code. SELECT * FROM...
  3. C

    update table from select

    Pat, You made that sound too easy lol. I never used the query wizard stuff but I will give it a shot. Thanks for the advice! -Chris
  4. C

    update table from select

    Michael, I tried taking the () out and that did not work. I have the right steps in regards to UPDATE... SET... WHERE.. I'm using JOIN in the SELECT statement, not in the UPDATE. spikepl, You are right about using EXISTS. I was trying to go around it when I know I have to use it :banghead...
  5. C

    update table from select

    Hi All, I'm trying to update two columns (f13, f14) table based on a select statement. If I run the select statement on its own I get the desired results. Now I need to update those records. I get this error message when trying to run the code below. "You have written a subquery that can return...
  6. C

    check duplicate records within same table

    Tyler, There is a auto increment primary key field in the master table, not this one. This is a temporary table that holds that data until it gets imported into the master table. The way to tell which record is the newest is by the CTRL#. The greater the control number, the newer the record...
  7. C

    check duplicate records within same table

    I forgot to paste my code. Any help would be greatly appreciated. SELECT Edi_out.F3, Edi_out.F4, Edi_out.F5, Edi_out.F6, Edi_out.F7, Edi_out.F8, Edi_out.F9, Edi_out.F10 FROM Edi_out WHERE (((Edi_out.F3) In (SELECT [F3] FROM [Edi_out] As Tmp GROUP BY [F3],[F6],[F7],[F8],[F9] HAVING Count(*)>1...
  8. C

    check duplicate records within same table

    I used the query wizard to help me identify the duplicate rows. Now I need to update the "Duplicate" column for the older record to "Yes". If you look at the first two records in my sample data you will see what I'm talking about. I thought the query wizard would give me an option to do so but...
  9. C

    check duplicate records within same table

    jdraw, I did not even think of that lol. I will look into that and get back to you. Thanks for the advice. -Chris
  10. C

    check duplicate records within same table

    Hello All, I'm working on a query in access 2003 that will check (records within the same table) to see if records are duplicated. Do I need to sort the table? If so I would sort it by FROM_ID, TO_ID, TRAN, PO#, INVOICE#, CTRL#. Here is an example of duplicate and non duplicate records...
Back
Top Bottom