Search results

  1. V

    how to join the table with query based on 'like' clause

    Hi, Can someone guide me here please and suggest how I can achieve this in Access I have a table created in Access- "Master" FileName Sortorder ABC_ ..........4 CDE_ ..........2 EFG.ss1.......1 GHI.srs........3 … I have a Query created in Access whose output is FileName RowCount...
  2. V

    how to add counter to a field based on the instance of appearance

    I am a reports developer and never worked with Access, but got hands on the new project to create an access report with sql server db. Background: I have a table which returns 4 fields- Name, rows, exception and rundate. Sample DB Data- Filename RowCt ExceptionCt RunDate A 10 0 11/11/2014...
Top Bottom