Forms and Division

[SpeedStick]

I have form that I trying to complete. I have 1 text box that I used this function (=Sum([CountOfPT])) to total the number of records for a field.

I need to take this field and divide by this: Table Name:Total Field Name: TotalPT.

How do I format a DLookup to pull Total!TotalPT into the form. Then divide (=Sum([CountOfPT])) by Total!TotalPT? I need to display the out put of the output in third text box.

Thank you for your help.

 

[dhookom]

Does the total table have only a single record? If the table isn't in the form's record source then you can use DLookup to pull the field value.

Duane
Hook'D on Access
MS Access MVP

 

[SpeedStick]

Dear Duane,

Thank you for your response.

Yes, this table has single record. I tried to use DLookup with this format

=DLookup("TotalPT" , "Total")

However, I get an error message when using this formula.

Scott

 

[SpeedStick]

All I want to display is this single record "TotalPT" on this text box.

 

[dhookom]

Please check that you have a table named "Total" and a field named "TotalPT".

What is the error message?

What is the name of the control?

Does the form need to allow edits?

Duane
Hook'D on Access
MS Access MVP