I am trying to make a calculated value display on a form, specifically count the number of outage entries. The calculated value comes from a query - rpt_90_all_exec_summary Qry. In the query I have a column that says - countoutage#: Iif([Outage#]Is Not Null,1,0). The query is sourced from the table - Major_Storm. The form ia a "tab" type who's record source is set to the main table - Major_Storm. The control source in question is - =Sum([rpt_90_all_exec_summary Qry]![countoutage#]. I am trying to count total outages. It return's the response - #Name?. Help !!
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Display calc ctrl on Form
- Thread starter ddmtn546
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question