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