Search results for query: *

Thanks Skip.. This will be a ongoing event each month. I used a form to manually select multiple rows and delete but would like to do it in the table. When imported it does leave null rows between each set of duplicate values. I don't know if I could do a loop and look for the duplicate value...

Thanks Jeff!! I will try this and get back to you..

i really do apprciate the help.. This is my last hurdle and can not figure it out. This file is going to be exported and used as an input file to automatically update prices on finacial records. Is there a way to look for NULL values and copy the cell above it. This way I can execute a duplicate...

Yes but that only deletes the line with "PT ORD EST" in it. I need the docno that are above it to be deleted.

This is the attachment with the corrected highlighted items that I am trying to delete. Thankshttp://www.mediafire.com/file/e939ts4jsj3k184/Tbl_out_Query.xlsx

Delete the Docno's where there is a PT ORD EST. These are estimates and I do not need them.

This may help. I have exported the table to excel and highlighted the rows I have to delete. I can not figure out on how to delete the rows.http://www.mediafire.com/file/e939ts4jsj3k184/Tbl_out_Query.xlsx

Thanks for the input.. I am trying to move forward. What I am trying to do is take an input table with duplicate numbers in a column, (which I need) and the column with "PT ORD" has nulls in the total row except for the price and remarks columns (which has PT ORD) and I can not associate the row...

Thanks for the input. The line the PT ORD is on is all Null exept for the amount and remarks "PT ORD" and i can not seem to pull it. Any ideas? Previos post I asked if i could copy the docno above it and paste it in the null cell. This way I can execute a delete on the dup docno with PT ORD in...

Text document I import this into a ACCESS table. I need to delete the matched expenditure and Difference and PT ORD. I was thinking is to copy the cell above it when PT ORD is in the cell. This will allow me to delete all the records that are duplicate with PT ORD. What do you think...

I hope this can be done. I have been trying different ways to do this and maybe somebody can steer me in the right direction. My problem is: I want to copy column1 lineA value of 1111 to the null vaule below it If COLUMN2 LineB = XXXX Is this possible? column1 column2...

I have a problem and can not figure it out. I have duplicates in one column and a second column with data but located below the duplicate records with no duplicate records to tie it in. The duplicate records are above the criteria for deletion. I would like to delete this criteria from the...

Thanks for the input. I will try the VBA coding area.

Thanks for the input. I am trying to get it to work but the problem is the column one has the duplicate records and some of the duplicates will not be deleted.. all depending on column 2 data which does not have the duplicate value in column 1. Still trying to move forward.. Thanks

Is there a way to loop thru looking for duplicated values in a table "column1" and look at the next row in column2 for a value and if the value equals BBB then delete it? column1 column2 AAA AAA -------------BBB CCC CCC CCC -------------BBB