very important DLookup

[Guest]

Hi all,

I need as many samples as possible that displays in an unbound text box the
value that exists in table (with explaination please)
Examples: in a table that contains fields :agent,shift,date,skill,total number

1-how to display the total number of agents whose skills are equal to the
[skills] box on a form,and on adate that equals the[dateM] ,and shift equals
to the [shift] box.
2-How to display the agents name whose skills are equal to the [skills] box
on a form,and on adate that equals the[dateM] ,and shift equals to the
[shift] box

and so on ,please i need as many samples as possible,you can refer me to a
site to get this (preferable on microsoft .com

 

[strive4peace]

Hi Pietro,

instead of displaying all the choices in an unbound textbox (you will
have to send them to a routine to concatenate values, which I can give
you code for if you really want it)...

consider writing the results to a listbox...

you can then build the SQL to limit the listbox to the controls that are
filled out on your form

in order to do this, you will need to become mo familar with SQL -- now
wait, it is not hard to learn -- email me and request my 30 page Word
document on Access Basics; that should get you started


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*