I want to be able to click on the "filter" of column and provide me a drop down of the data. At this point I want to be able to select all the line items with that same data.
I have a customer database where multiple customers have the same customer ID. I want to be able to find these customers via their Custom ID and only show them with a push of a button.
Filter Data or Query in a Column
Filter Data or Query in a Column
Apache Open Office 4.1.9
Mac OS Big Sur Version 11.3.1
Mac OS Big Sur Version 11.3.1
Re: Filter Data or Query in a Column
The attached database has one table with a text field "N", a field of possibly duplicate ID numbers "FK" and a primary key "ID". 500 records with 136 duplicate FKs.
A query selects all FK that occur more than once.
A form lists these FK dupes and shows the related table records in a subform.
A query selects all FK that occur more than once.
A form lists these FK dupes and shows the related table records in a subform.
- Attachments
-
- Dupes.odb
- Find and edit duplicates
- (24.28 KiB) Downloaded 163 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice