Recent content by davegauthier

This certainly helps. I think he wants to store the calculated field to use in other calculations. Would it be just as easy to simply use all the payments individually for the other calculations as well? Also, when using/entering this information on a form, on the given form there is only one...

I am creating a db for a property management company. They want to be able to enter the monthly payment made each month on each property (there will be multiple properties involved) and also have a field that totals all payments made by the tenant over the course of their lease. What might be...

I can asure you there is no repeated data. There is simply a lot of data needed for each client. The relationships are set up a-->b a-->c a-->d a-->e a-->f a-->g How can I screen shot my Relationships window to post and be sure it is done properly? With regards to the query, are you...

First, sorry for the double-post. It was advised to me to not have just one table with all the information stored, because once there were many records in that table, it entire database would run slower. So, I split the data into 7 sub-categories. The problem is, when I enter some info that...

I have 7 tables to track client data. The 1st table uses AutoNumber to create the 'Client ID' number. The other 6 tables are linked to this table, and in turn each other, through the 'Client ID' field. All information entered in all 7 tables is done so on one form. This form has a tab...

I have 7 tables to track client data. The 1st table uses AutoNumber to create the 'Client ID' number. The other 6 tables are linked to this table, and in turn each other, through the 'Client ID' field. All information entered in all 7 tables is done so on one form. This form has a tab...

Thanks, it works like a charm now. I appreciate the help from both of you.

I need to print a report based on a single record taken from a group of records. The one record I want to print in the report would be the record currently being viewed in the main form. This is a client database. I have multiple tables with all information connected with Client ID's and...