nimblefingers
Technical User
Hi ACCESS Gurus,
I have a table with a thousand rows, 15 columns. The only unique field is the entryID (auto number). Other columns are Path, FileName, Title, EspChronID, IwChronID, four columns of relevanat dates, etc. I've made a form that shows all 15 fields and can do simple searches and can add and update records. The EspChronID column can have duplicates chonicle IDs.
What I need is a "?? box" on the bottom of the form to show the Path, FileName, Title, and IWChronID if the simple search of any of the fields show a duplicate EspChronID. A query In (SELECT [ESPChronID] FROM [CSInfo-ESP] As Tmp GROUP BY [ESPChronID] HAVING Count(*)>1 ) was created to show the duplicates.
Any help is greatly appreciated.
Thank you.
I have a table with a thousand rows, 15 columns. The only unique field is the entryID (auto number). Other columns are Path, FileName, Title, EspChronID, IwChronID, four columns of relevanat dates, etc. I've made a form that shows all 15 fields and can do simple searches and can add and update records. The EspChronID column can have duplicates chonicle IDs.
What I need is a "?? box" on the bottom of the form to show the Path, FileName, Title, and IWChronID if the simple search of any of the fields show a duplicate EspChronID. A query In (SELECT [ESPChronID] FROM [CSInfo-ESP] As Tmp GROUP BY [ESPChronID] HAVING Count(*)>1 ) was created to show the duplicates.
Any help is greatly appreciated.
Thank you.