======================= | user_id | dept | ----------------------- | 23 | Accounts | | 17 | HR | | 17 | Support | | 19 | Accounts | | 4 | Marketing | =======================
This makes the query needed for the report much simplier. You could even add a timestamp field and record when a user interacted with a department.
Sheila http://www.shefen.com/
[EMAIL PROTECTED] wrote:
I need to search an entire table for a value, and then report back what field it was found in... how on earth do I do that?
I've a list of departments, as field names.
whenever a user interacts with that Dpet, I wanna add thier id No to the appropriate field.
so I'll be left with a table that looks like this:
======================================= | Accounts | HR | Support | Marketing | --------------------------------------- | 23 | | | | | | 17 | | | | | | 17 | | | 19 | | | | | | | | 4 | =======================================
So User 17 has dealt with HR and Support, and user 23 has dealt with only Accounts.
So I wanna input an user ID no, and then get told what Dpets have been accessed...
I need to learn this, as I know it's simple, but I've never had to do it before!
Tris....
____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016
Please include the email address which you have been contacted with.
