where is your attempt that you did not finish?
Also you need to explain what you mean by 'volume processed by the team on a daily basis'
mock up what you expect the final result to look like
Hi
You have data in 2 tables - tbl_Bala and Sheet1
How are these 2 tables related?
Hi
Not following your process.
You say "Data which i am entering in ONFS_Vault should save in tbl_Bala"
What is ONFS_Vault ??
If you want to store data in tbl_Bala then you would create a Form based on tbl_Bala
Hi
Your tbl_Bala has lots of repeated data as shown in the attached.
What data is in Sheet1???
View attachment 75467
SELECT tbl_bala.[User Name], tbl_bala.Date, Count(tbl_bala.ID) AS CountOfID
FROM tbl_bala
GROUP BY tbl_bala.[User Name], tbl_bala.Date
ORDER BY tbl_bala.[User Name], tbl_bala.Date;
Hi
Why put exactly the same data into a table multiple times??
I don't see any Team by which to aggregate.This query gives the number of entries per person per day
Code:SELECT tbl_bala.[User Name], tbl_bala.Date, Count(tbl_bala.ID) AS CountOfID FROM tbl_bala GROUP BY tbl_bala.[User Name], tbl_bala.Date ORDER BY tbl_bala.[User Name], tbl_bala.Date;
Is that what you want?
I am looking for tracking file for each person and one master file (to pull data from tracking files).
Tracking file should have form to capture the details like; Date, User Name, Plan #, Plan Type, Participant Name, Task Type, Status, Action Taken, Time taken.
Each person will use the file and enter the details in the form this data should capture in backend.
Isn't there a 'tracker' as a free template for Access? I don't have my machine available at the moment to look.
I found one 'Tracker' task management.. Could you please recreate it as per my requirements.
Er, no. The idea of this forum is we help you to learn how to do things yourself or help you with a problem you cannot find the answer to. I'm sure very few people on here write or adapt software for free, we all use Access in our work. Me personally, I get paid to write software and am always very busy with work. I don't mind helping but if you want me to write something for you, I'll need to get paid. Sorry.