Search results

  1. V

    MS-Access Unmatched records to be set as default value

    Hi Folks, Need your expert advice on MS access query, below the scenario for your reference. I have 2 different Table (Table1 & Table2) Table1: Team Activity Jan-2019 Feb-2019 Group1 Type1 10 20 Group2 Type1 15 22 Table2: Team Activity From To Percentage All All Jan-2019...
  2. V

    Question Text Column to be converted to Date/Time

    Hello Experts, This is my 2nd post in this forum regarding MS access 2007 help. Unfortunatelly i am working on a senstive information pleae excluse me for not posting the DB here. I am stuck need help on converting a text column to Date/Time format please I Have imported this table from...
  3. V

    Access SQL Query to Pivot based on one colum

    Hello Experts, Need your help on desiging my first access query, I am working on a Daily dashboard tracker for which i have 3 sheets in excel as mentioned below Sheet1 = Attendance & Break dump Sheet2 = Training and Meeting dump Sheet3 = Headcount file with staff intime details day wise I...
Top Bottom