Search results

Hey friends, I am looking around for a way to compare two tables. Compare by what i mean is update the first table too. I have attached an example file. Here, There are two tables: "New Table" and "Original Table". Now, I need to check if any new data exists in "New table". If yes, I need to...

Hi friends, I need to show the value of a subform in the mainform which pertains to the unique "Proposal Number". Please find the attached where I have shown the date textbox and the subform. The question is, Can I get the value of the last entered date in the date subform, to the main form...

Hi Friends, Please find the attached screenshot. As usual, am stuck up with a problem from 2 days. (could not attach the file, as its too large) In the screenshot, there are two fields in the SUBFORM of the Main form. They are: FTE Count and Mandays. I need to have FTE count as a calculated...

Hi all, Here is a small question. Maybe easier, but as am a newbie, not able to find out. I have the below query which pulls the information. There is a "where" condition which works perfectly when I input any data like "WHERE ((([Proposal Table].[EBS Project ID]))) = "2435". However, I do not...

Hi all, This is my first question in this forum. Hope I get help. I have a database created. Now I am not able to write the queries. I have attached the mdb file with this. What I need is: 1. No. of resources Onsite / offshore – Project wise(Proposal Number is the Key) with planned and...

Hi all, I am new to Access and also this forum. I need to create a list for attandence. In other words, I have a data and it should be mannered in such a way that, it should include the leaves taken, number of absentees in a day, remaining leaves, etc., Some information I request are: 1> Is...

Hi all, I am new to Access and also this forum. I need to create a list for attandence. In other words, I have a data and it should be mannered in such a way that, it should include the leaves taken, number of absentees in a day, remaining leaves, etc., Some information I request are: 1> Is...