Need help calculating a total in a form from a query. Is this possible? (1 Viewer)

B

Brian0721PA

Registered User.

Local time

Today, 05:36

Joined

Aug 6, 2003

Messages

19

• Aug 6, 2003

• #1

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

Now Known as ___

Local time

Today, 05:36

Joined

Sep 11, 2002

Messages

723

• Aug 6, 2003

• #2

Use DLookUp in an Unbound TextBox...

Code:Copy to clipboard

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

IMO

 

B

Brian0721PA

Registered User.

Local time

Today, 05:36

Joined

Aug 6, 2003

Messages

19

• Aug 6, 2003

• #3

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

Now Known as ___

Local time

Today, 05:36

Joined

Sep 11, 2002

Messages

723

• Aug 6, 2003

• #4

Code:Copy to clipboard

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

In the Control Source of the UnBound Text Box

IMO

 

B

Brian0721PA

Registered User.

Local time

Today, 05:36

Joined

Aug 6, 2003

Messages

19

• Aug 6, 2003

• #5

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

Now Known as ___

Local time

Today, 05:36

Joined

Sep 11, 2002

Messages

723

• Aug 6, 2003

• #6

What is the ID Control Name on the Form?

IMO

 

B

Brian0721PA

Registered User.

Local time

Today, 05:36

Joined

Aug 6, 2003

Messages

19

• Aug 6, 2003

• #7

Form Name

The form is just called "Info Form"

 

IMO

Now Known as ___

Local time

Today, 05:36

Joined

Sep 11, 2002

Messages

723

• Aug 6, 2003

• #8

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

IMO

 

B

Brian0721PA

Registered User.

Local time

Today, 05:36

Joined

Aug 6, 2003

Messages

19

• Aug 6, 2003

• #9

ID number

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

Thanks a ton for your help!

 

IMO

Now Known as ___

Local time

Today, 05:36

Joined

Sep 11, 2002

Messages

723

• Aug 6, 2003

• #10

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

IMO

 

B

Brian0721PA

Registered User.

Local time

Today, 05:36

Joined

Aug 6, 2003

Messages

19

• Aug 6, 2003

• #11

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

Now Known as ___

Local time

Today, 05:36

Joined

Sep 11, 2002

Messages

723

• Aug 6, 2003

• #12

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

IMO

 

B

Brian0721PA

Registered User.

Local time

Today, 05:36

Joined

Aug 6, 2003

Messages

19

• Aug 6, 2003

• #13

Here it is

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

i appreciate it alot!

 

Attachments

• copy of finality.zip

  60.1 KB · Views: 89

IMO

Now Known as ___

Local time

Today, 05:36

Joined

Sep 11, 2002

Messages

723

• Aug 6, 2003

• #14

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