I have a form with a text box that has a formula in it that works correctly. That data is not stored in a table. how do i query that data to carry out some calculations? I'm pulling my hair out!!
Novice
Windows XP 
Access 2007
I have a form with a text box that has a formula in it that works correctly. That data is not stored in a table. how do i query that data to carry out some calculations? I'm pulling my hair out!!
VIP
Windows 7 64bit Access 2010 32bit
What data is not stored in table? The data used in the calculation? Where does it come from? Do calculation in query if you want it available to another query.
The alternative is for query to reference the textbox but then the form must be open for the query to run.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Trying to populate a text box on form with the result of a query
To open a form, sub form if text box entry exist in Query
How do I Query based upon whole word value in form text field
Posting Permissions
Reply With Quote