Hi all, I am preparing a database where i need to have a table to enter forecasted hours per each week for all associates ( there is another table with list of all associate names ). And also i need a form to enter weekly details into the table.
Please share if you already have any database...
Hi.. I am preparing a database for which only few people should have access to the main database... and all the team should be able to input the data at a time... So, I thought to do it with DAO recordsets.
My question is that... if all the team tries to input the data at a time, is there...
Hi...
I have prepared a database to input the volumes for each activity.... I want to prepare query to calculate growth rate of volumes for each team wise based on previous year's volume for two weeks...
Here is the example.. Assume that today is 04/23/2009, I want the database to go back to...
Hi, Really Im so thankful for ur support in this...
Finally, I have come to an end with this queries.... But need ur assistance for the last time... Actually I prepared the final query called copy of query1 ( see in the screenshot) . In that I am Ok with calculated FTE field.
The problem is...
Yes, it has got solved. Thanks for that.. and one more thing i wanted to in this database is...
I have the cycle times for each activity in activity table, I just wanted to have a query in such a way... It will give me the time spent on all those activities per each day group by date and team...
Thanks so much for reply.. actually i am new to database... so i dnt knw much abt normalisation n all....
The second picture... i made it manually in excel to give more clear picture abt the requirement.
but wht u said in the last post is right.... I want the data from two tables.. Is it...
Hey... Thanks for ur reply.. but i think.. its still not giving me d results as i wanted... just iam attaching a image that shows exactly wht r d results i am expecting from that query from those tables in the attached database....
Hi all,
Actually i am preparing a database. In that i need to develop a query in such a way i have explained it in attached picture.. i have created one query called query1 but that is giving wrong results... please check that and correct that...
Attaching database and problem picture...
Thanks