Need help calculating a total in a form from a query. Is this possible?

[Brian0721PA]

okay, here is the situation. I have a table where i put monthly liabilities (monthy payment). i then have a query that total's all these payments up for each individual client. They all appear as total's in the same query. I have a form where I have information about the client. I want to transfer that total monthly payment to the form. How do i go about doing this? I'm sure this is an easy question, but I haven't used access in a long time. any help would be greatly appreciated. Thanks a ton!

Brian

 

[IMO]

Use DLookUp in an Unbound TextBox...

=DLookUp("[TotalFromYourQuery]","NameOfYourQuery","[ID] = '" & [ID] & "'")

IMO

 

[Brian0721PA]

more specific

Okay, still a bit confused. so here is what i have. The query name is "Monthly Payment" The field in the Query is "SumOfMonthly Payment" So what would the exact code be that I need then? Help is greatly appreciated.

Thanks a ton!

Brian

 

[IMO]

=DLookUp("[SumOfMonthly Payment]","Monthly Payment","[ID] = '" & [ID] & "'")

In the Control Source of the UnBound Text Box

IMO

 

[Brian0721PA]

still not working

Okay, I put that in and it still doesn't work. Let me be more specific on this database. It keeps records of clients, their mortgage information and monthly liabilities. I have a table that i put liabilities in to. the query then totals them up by name. this query has 2 fields: "client name" and "sumofmonthly payment" The form still won't bring that total monthly payment into the form. any more suggestions would be greatly appreciated.

Thanks alot!

 

[IMO]

What is the ID Control Name on the Form?

IMO

 

[Brian0721PA]

Form Name

The form is just called "Info Form"

 

[IMO]

I mean, Have you got an ID Number in the table the Form is based on?

IMO

 

[Brian0721PA]

ID number

No i dont, should i do that? if so, how do i do that?

Thanks a ton for your help!

 

[IMO]

Could you post a stripped down version of your DB. It sounds like you may need to normalize it first.

IMO

 

[Brian0721PA]

DB

Ive taken everything out possible and I ZIp'd it, but its still too big for what is allowed on the website. I could email it to you, what is your email addy?

 

[IMO]

Did you Compact and Repair? Tools >>> Database Utilities >>> Compact and Repair Database

IMO

 

[Brian0721PA]

Here it is

Okay, here is the DB. let me know what you can do. Thanks alot!

i appreciate it alot!

 

[IMO]

I've taken a look at your DB, you'll have to normalize it for it to work properly. Do a search here for Normalize or Normalise and you'll see what I mean.

IMO