Suppose I begin with an unbound blank form, and drop a textbox control onto it.
Can I somehow cause that solitary textbox to display the result of a single field in SQL statement with an aggregate function like Sum()?
The end result will be a textbox that simply reads something like 249 lbs. I'm not trying to display multiple records or anything fancy.
A little more context, if anyone cares: I'm trying to get a textbox on a form to tell me the Sum(tblProducts.Weight) WHERE a certain criteria is true which will distill the result set down to a single record with a single field... should be easy to display in a textbox. I already have a query yielding 1 cell of meaningful data, I just need to get it onto the textbox in the form. The truth is the Form is already bound to something completely different and it makes no sense (for my simple mind) to bring in the Products table to the Forms Recordsource and run a Sum() on a field bound within.
Any thoughts? Thank you,
Matt