RE: Looking for a database function

[John Bruin <john -dot- bruin -at- nec -dot- co -dot- nz>]

If you have some familiarity with Excel then using a combination of Excel
"hlookup", "vlookup" and "if" functions can do this quite easily. 

You would set up a table with value 1 entered as your X and then beneath the
table set up two columns of formulae : one to list procedures  and one to
list employees.

Setting up the formulae would be a little fiddly, but as it is probably a
one-off, not too onerous. Once set up then you would "query" by typing "Joe
Dobbs" in a particular cell and it would show all his procedures. Likewise,
typing the name of a procedure in another cell would show a list of
employees trained in it.

the 2 sets of formula would look something like this:

=IF(VLOOKUP($B$19,A$1:H$14,2,FALSE)=1,B1,"")

=IF(HLOOKUP($E$19,A$1:H$14,2,FALSE)=1,A2,"")

where:
	- b19, e19 is the query value for procedure/ employee
	- a1:h14 is the table
	- 2 is the column/row offset  (need to manually change for each
element)
	- false = exact match
	- b1/a2 = row/ column headers (this is the bit that returns the
procedure/employee if the value is 1 and creates the list)


Just another option to consider, and relatively simple if you don't mind
playing with Excel (or have a friend who can help you)

John	


> -----Original Message-----
> From: 
> techwr-l-bounces+john -dot- bruin=nec -dot- co -dot- nz -at- lists -dot- techwr-l -dot- com 
> [mailto:techwr-l-bounces+john -dot- bruin=nec -dot- co -dot- nz -at- lists -dot- techwr-l -dot- c
> om] On Behalf Of Dan Goldstein
> Sent: Saturday, 8 May 2010 4:06 a.m.
> To: techwr-l -at- lists -dot- techwr-l -dot- com
> Subject: Looking for a database function
> 
> It seems obvious to me that this should be doable -- not 
> necessarily in Access, any program will do!
> 
> I want to create a grid in which one axis lists several dozen 
> company quality procedures (by the released document 
> numbers), and the other axis lists several dozen company 
> employees. Each employee has to be trained in certain 
> procedures, so for each employee there's a list of procedures 
> and for each procedure there's a list of employees.
> 
> To indicate that a given employee has to be trained in a 
> given procedure, I want to just mark the grid at that intersection.
> 
> I need to be able to query in both directions. In other 
> words, when a procedure is revised under document control, I 
> need a list of the employees to be trained in the revisions. 
> And when an employee is replaced, I need a list of the 
> procedures to train the new employee in.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> This message contains confidential information intended only 
> for the use of the addressee(s). If you are not the 
> addressee, or the person responsible for delivering it to the 
> addressee, you are hereby notified that reading, 
> disseminating, distributing, copying, electronic storing or 
> the taking of any action in reliance on the contents of this 
> message is strictly prohibited.  If you have received this 
> message by mistake, please notify us, by replying to the 
> sender, and delete the original message immediately 
> thereafter.  Thank you.
> 
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> 
> Use Doc-To-Help's XML-based editor, Microsoft Word, or HTML 
> and produce desktop, Web, or print deliverables. Just write 
> (or import) and Doc-To-Help does the rest. Free trial: 
> http://www.doctohelp.com
> 
> 
>  - Use this space to communicate with TECHWR-L readers - 
>    - Contact admin -at- techwr-l -dot- com for more information - 
> 
> 
> ---
> You are currently subscribed to TECHWR-L as John -dot- Bruin -at- nec -dot- co -dot- nz -dot- 
> 
> To unsubscribe send a blank email to
> techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
> or visit 
> http://lists.techwr-l.com/mailman/options/techwr-l/john.bruin%
> 40nec.co.nz
> 
> 
> To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com
> 
> Send administrative questions to admin -at- techwr-l -dot- com -dot-  Visit
> http://www.techwr-l.com/ for more resources and info. 
> 
> Please move off-topic discussions to the Chat list, at:
> http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat
> 
> 

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Use Doc-To-Help's XML-based editor, Microsoft Word, or HTML and 
produce desktop, Web, or print deliverables. Just write (or import) 
and Doc-To-Help does the rest. Free trial: http://www.doctohelp.com


 - Use this space to communicate with TECHWR-L readers - 
   - Contact admin -at- techwr-l -dot- com for more information - 


---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot- 

To unsubscribe send a blank email to 
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot-  Visit
http://www.techwr-l.com/ for more resources and info. 

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat