Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2008

Tip: Looking for answers? Try searching our database.

Math in queries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gary Hull - 26 May 2008 13:47 GMT
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) - 26 May 2008 15:12 GMT
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;

Signature

       Ken Snell
<MS ACCESS MVP>

>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
[quoted text clipped - 7 lines]
>
> Thanks for your help
Jan Baird - 27 May 2008 20:52 GMT
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 - 27 May 2008 20:51 GMT
Jan Baird is out of the country until September 20.   Every effort will be
made to respond to messages, but please be patient.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.