Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by locloc
-
MS Access Parameter value error in simple query
Thank you - the new code works perfectly.- locloc
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
MS Access Parameter value error in simple query
Also, the underlying value (SumVL,SumP4) is a calculation of the sum of a number of records, made in another query - i can't think how to incorporate that into one sql statement.- locloc
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
MS Access Parameter value error in simple query
thanks - still not working - i copy/pasted the sql into a new query - same error. i looked in the properties box and did not find anything like parameters? what is that called in the list of properties please? thank you- locloc
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
MS Access Parameter value error in simple query
in my query i have 2 calculated fields (SumVL and SumP4)i want to divide one by the other([SumVL]/[SumP4]). I get a message box "enter parameter value" for each itenm (SumVL and SumP4) . i don't enter any value, and then the query calculates correctly. how can i eliminate the parameter value...- locloc
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
