Math in queries

[Gary Hull]

I am working on a project to figure cost to install Millwork
I have a form where I enter the cost to install each item on
this form I am using and unbound textbox in the footer to
total the cost column
I need to use the cost total in a calculation to figure trip
cost
All of this is tied to a job table
I plan on using a query to figure the trip cost
How do I bring the total install cost into that query?

Thanks for your help

 

[Ken Snell \(MVP\)]

You can reference a textbox from a form in a query, so long as the form is
open at the time:

SELECT Forms!NameOfForm!NameOfTextbox AS TheValue,
TableName.Field1, TableName.Field2
FROM TableName;

 

[Jan Baird]

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.

 

[Jan Baird]

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.