I had this question after viewing syntax error in query expression in MS/ACCESS 2016 (DLOOKUP)
Presently i am using below query in a Listbox (with single column), to get a desired qty on a Form.
SELECT Sum(tblLifting.Lift_Qty) AS SumOfLift_Qty
o]) AND ((tblLifting.Lift_Date)<=[
Now as i want to do some calculation on the above value, i wish to get the above result in Textbox and not in Listbox.
In short, i want to convert this qry into a txtbox value.
How can i achieve this ?