Comparing multiple lists

[Guest]

Hello All,

I have a situation where I have a master list of about 2000-2500 entries and
then there are few lists of varied number of entries. I want to compare this
master list with all these other list and at the end, get an excel sheet
where one column will have all entries from master sheet and then next few
columns will have checkboxes, if certain entry is present in either of the
lists I am comparing with.

Any idea how this can be done?

Also, when you import any excel sheet in access, it removes all formatting,
is there any chance to keep this formatting, like colours etc?

Thanks

 

[John Vinson]

Hello All,

I have a situation where I have a master list of about 2000-2500 entries and
then there are few lists of varied number of entries. I want to compare this
master list with all these other list and at the end, get an excel sheet
where one column will have all entries from master sheet and then next few
columns will have checkboxes, if certain entry is present in either of the
lists I am comparing with.

Any idea how this can be done?

You can create a Query joining your master list to each subsidiary
list by the unique ID in the lists (there is a common field that
uniquely identifies each record... I hope!?).

Select the Join line in the query, and choose Option 2 (or 3,
depending on how you added the tables): "Show all records in <main
table> and matching records in <child table>".

You can then include a calculated field to create your checkbox: in a
vacant Field cell type

HasData: Not IsNull([childtable].[fieldname])

where fieldname is the name of the linking field in the child table.

Also, when you import any excel sheet in access, it removes all formatting,
is there any chance to keep this formatting, like colours etc?

No. Access IS NOT A SPREADSHEET and doesn't work like a spreadsheet.
You can get formatting to your heart's content on Forms or Reports...
but not in tables.

John W. Vinson[MVP]