urgent urgent urgent urgent

urgent urgent urgent urgent

Post by UGlldHJ » Sat, 12 Aug 2006 20:12:01



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
 
 
 

urgent urgent urgent urgent

Post by V2F5bmUtSS » Sat, 12 Aug 2006 21:33:02

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.

 
 
 

urgent urgent urgent urgent

Post by Tony Toew » Sun, 13 Aug 2006 03:36:20


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.yqcomputer.com/