Recent content by varadha_72

Can someone PLEASE help me with the above request. I need to get this done.

Thanks Access Gurus, hats off to you all for your help. I was able to achieve my result based on Galaxion's suggestion. I will be needing another help from you guys. I need to put some kind of counter for the instance of filename occurrence. I.e. If you notice in the below example, in row...

Thanks for the reply, but I cannot use Left function and also cannot validate string for 4 characters, since each and every filename is different in last few char only, and some of the file names have similar 5-9 char.

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...

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...