Sql select statement in controlsource field - possible/not possible?

[Salisha Khan]

Is it possible to create a select statement as the control source for an
unbound text box?
For example I have a report which is based on a query. Now I want to create
an unbound text box with a calculation it it.
something such as Sum([FieldName)] where [and my criteria]
Is it possible to do something like this in the properties box Control
Field? Please help!
salisha

 

[[MVP] S. Clark]

ControlSource expression examples:
=Date()
=Sum([otherfield])
=txt1 + txt2
=Dlookup("z", "table", "fieldid = 2")


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Salisha Khan]

Thank u for your help

ControlSource expression examples:
=Date()
=Sum([otherfield])
=txt1 + txt2
=Dlookup("z", "table", "fieldid = 2")


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Is it possible to create a select statement as the control source for an
unbound text box?
For example I have a report which is based on a query. Now I want to create
an unbound text box with a calculation it it.
something such as Sum([FieldName)] where [and my criteria]
Is it possible to do something like this in the properties box Control
Field? Please help!
salisha