#1
|
|||
|
|||
Check for duplicated data and print list
I have an access spread sheet and I want to check an excel spread sheet to compare data ie and job references. The job ref there will be 4 different columns in the access database, and a I get a list of jobs via a spread sheet, which might have one of the 4 or all of the 4 job ref's how would i get the database to check the spreadsheet data for duplicate data and print a list of the duplicated. The access data base could have a temperory table for importing of the spreadsheet then a button to check for duplicate and populate a query and then print the quiery out.
|
#2
|
||||
|
||||
Hi
can you show what you already have and where it went wrong?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Is it the Excel spreadsheet you want to check for duplicates or the Access table?
Excel has a built-in function on the Data tab called Remove Duplicates and you just select which columns you want to check for duplicates, e.g. Job Ref, and it will do it for you. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why 'print forms data' print pictures for DOCX files | koolprasad2003 | Word | 4 | 05-09-2014 03:26 PM |
How to edit cell data without changing print area. FIXED print area | VictoriaT8 | Excel | 3 | 02-22-2013 07:54 PM |
Check which ListGalleries a list belongs to? | tinfanide | Word VBA | 5 | 06-29-2012 07:47 AM |
Word Macro That Checks a Check Box Form Field When File Print is Executed | DKerne | Word VBA | 4 | 06-09-2011 11:54 AM |
Words are duplicated on print | agentred | Word | 1 | 06-29-2010 08:45 AM |