urgent urgent urgent urgent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

what should i write in the controlsource of a text box on a form to disply
the total of the agents whose skills is "TSLM" and shift "9:00" on the date
that equals the Form's date ,based on the below query

Date Shift Skills Total of agents
 
Hi Pietro

You "could" place an unbound TextBox in the footer of the form with
something like

=Sum(IIf([Skills]="TSLM",[TotalAgents],)

Or in an unbound box on the record

=IIf([Skills]="TSLM" And [Shift]=9,[TotalAgents],)



--
Wayne
Manchester, England.
Not an expert will try to assist where pos.
Enjoy whatever it is you do.
 
Note that we are volunteers here. We help people out when we can.

I'd suggest planning for glitches next time you do something in Access
and to not leave any problems to the last moment.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top