Search results

  1. V

    MS-Access Unmatched records to be set as default value

    Hi Gasman, yes I had posted there in excel forum as well seeking for help, but later realised access forum would be the right one to do so for access related help.
  2. V

    MS-Access Unmatched records to be set as default value

    Hi CJ, Once again thank you for the effort that your putting on this. data for table2 is from userform input so each time the user enter the input old or existing data in table2 gets deleted and the new row will be added. Then the from and to month in table2 it could be anything between...
  3. V

    MS-Access Unmatched records to be set as default value

    Hi CJ, Yes table2 will have one row and the format is Date/Time in both the tables
  4. V

    MS-Access Unmatched records to be set as default value

    Table1 may have values for any number of month between a year say jan-2019 to Dec-2019. Data Type would be MMM-YYYY
  5. V

    MS-Access Unmatched records to be set as default value

    Hi CJ, Apologies for not being very clear in one go. Table1 will have Jan till Dec columns, I tried to change the design unfortunately that will impact some of the automations that is already running based on this design hence trying to find alternate solution with the current desgin.
  6. V

    MS-Access Unmatched records to be set as default value

    Hi CJ_London & Arnelgp, Thank you for your time, really appreciate your efforts. I have modified the table 2 below for better understanding. Basically this Table2 values is from a userfrom which will be input by Head and will have single row. Table1 will have multiple rows. Table2 having...
  7. V

    MS-Access Unmatched records to be set as default value

    Hi Ranman256, Thank you for your time, really appreciate it, Unfortunatelhy team is maintaining the records in this manner and since this is bank environment unable to change the source. Any solutionto the the current design that i have please.
  8. 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...
  9. V

    Question Text Column to be converted to Date/Time

    Hi Cronk, Perfect. It worked like charm. Thank you so much. You made my day...
  10. V

    Question Text Column to be converted to Date/Time

    Hello TheDbGuy, I have attached a sample picture of how Starttime column looks like. Hi Majp, I will try your suggestions too and keep u guys updated in a while. Appreciate your time...
  11. 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...
  12. V

    Access SQL Query to Pivot based on one colum

    Hi Minty, Very well said, your absolutly right and with your idea i was able to arrive at the below statement, however there is one more need in this for which i need your help please. Along with this i need to get one more column that is "start time" based on condition if type is avalable i...
  13. 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