Search results

Solved: Fields linked in subform Hi everyone, I have a form with a subform. In the subform there are a contract ID textbox and a client name textbox. I have the default values in both set to equal the value of fields in the main form. The contract ID in subform works, it takes on the value of...

Hi everyone. I built a data base with 3 tables, one for client data one for contract info and one for monthly data about each contract. The start and end date for the contracts in the contract table are in 3/3/1922 format. In the table that holds the monthly data for each contract, there is...

Hi all, I have a query that finds a location in one table and a start and end date for a contract in another table, many contract start and end dates for each location. I am trying to search by location and find the average length of the contracts at that location(avg length in days.) Every...

Hello everyone. I need help in the design of a database and any replies are appreciated. I need to make a data base that records member info, member contract info, and monthly payments. Each member will have personal info. Also each member will have many contracts, sometimes more than one...