Recent content by Ikkyu

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

Thank you CEH I will see if that works.

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

Re: Solved: Average length of days for a contract at several locations. I've got the average now. I can search by location and get the avg day by using one query to subtract the dates then a query using the firs query to get the avg. Now I can't round the days to one decimal. I set the decimal...

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

Thank you speakers_86. That's just what I needed. I understand a whole lot more after some research.

Thank you Speakers_86, I'm goin to do more reading.

I think I have my tables worked out. I have a book on access and I've looked online how to make forms, but I still can't figure this out. I made the tables as Speakers_86 suggested below: tblMembers MemberID MemberFirstName MemberLastName MemberAddress tblContracts ContractID MemberID (FK)...

Thank you for the tip on normalization. I just got finished reading an online tutorial about it. I do understand it a lot more. About the payment date, the payments are actually made in advance and used throughout the month. For instance, the member pays $1500 at beginning of contract that...

Wow, how did you understand my post? I was more confused after reading what I had posted. Thank you very much for your reply. I will try this, the only problem is instead of a payment date, I need to show a month and a year in my reports. BTW, what does (FK) stand for? Edit: I realized that...

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