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

  • Thread starter Thread starter Salisha Khan
  • Start date Start date
S

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
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Thank u for your help

[MVP] S. Clark said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top