Problem in aligning data by synchronizing (linking) time of two tables

[drkundu]

Yes, duplicates are records which has no data. At the same time, in the large table, there are some uniques which have no data too. Then how to remove duplicates with no data, but keep uniques with no data. I can do that in excel, excel takes lot of time to do the filter. Please let me know whether I can solve this issue in excel. Thank you Sir.

[June7]

Okay, this worked.

1. build query:
SELECT Master_Unique_Duplicate.NO2, CDate(Format([Time],"hh:nn:ss")) AS Expr1 FROM Master_Unique_Duplicate;

2. use that query as source to copy/paste records

[drkundu]

To build this query;

1. I am going to CREATE, then Query Design, then adding Master_Unique_Duplicate

Then I am confused what to do. If you add query design to the Access file that I have sent now and then send the file as an attachment, it would be very helpful. Thanks

[June7]

Just switch the query to SQL View and copy/paste the statement I posted.

Then switch back to Design View to see that structure.

Switch to Datasheet View to see the data.

Use that to copy/paste records. I simply selected all the records with ctrl-C, go to table and select the two columns (not the ID column) and ctrl-V.

Or save the query and use as the source for an APPEND sql action.

[drkundu]

It is really cool! I did not know about this option.


How to use that query as source to copy/paste records?