Math in queries

  • Thread starter Thread starter Gary Hull
  • Start date Start date
G

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
 
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 is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Back
Top