Recent content by drgn_str

It says 'You tried to execute a query that does not inclued the specified expression '[TotalCharges]+[Beginning July Balance]![BeginningBalance]-[TotalPayments]' as part of an aggregate function. That is the last error I received when I ran the query again. The time before that it just said...

I initially tried using a query because it is a lot easier to set up than VBA coding but I keep coming up with errors so I thought it would be "easier" to run a module to update the client balance when it loads the client. I know the answer is staring me in the face, I just can't see it yet.

It has been a long time (15years) since I have done anything with VBA coding and I need some help with the wording. I have a Client Information Form that I would like to have an Account balance that update when you load that client. I have three different tables that have information to be...

Thank you!!!!!!!!!!!:D:D:D

Okay so I need to have the Join Type: "Include all records from 'Client Info' and only those records from 'Charges' where the joined field are equal."?

It is a one-on-one relationship but when I go into Joint Type I have selected the 2nd option for each of the child tables: "Include all records form 'Charges' and only those records from 'Client Info' where the joined fields are equal." I had tried to do a one to many relationship but Access...

I guess I still don't understand joining then. I have the Client Info table as the parent table and both the Charges and Payment_Adjustment tables as child tables and both of them are pointing towards the parent table using FamilyID as the link. Should I have them set up in a more linear...

I have 3 tables: T1:Client Info- Fields: FamilyID, other fields related to client info two other tables are linked to the Client Info table T2:Payment_Adjustment- Fields: FamilyID, Amount, other fields related to payments. T3:Charges -Fields: FamilyID, FTFee, PTFee, FTDaysCharged...