Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cam
Starting Member
1 Post |
 Posted - 2003-04-28 : 17:40:31
|
| I need to write a forumal or query so that a document will print on a form. This is where the info is: part.user_5I have a list of values that if user_5 is, then I need the document to print.I was told that the @DECODE will do this but I'm not sure how to write it. Thanks... |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-04-28 : 19:07:57
|
| Are you using Microsoft Access? or Oracle?If Oracle then Decode acts like an case construct.If access then use iifCan you post the query that feeds your report or form.In Microsoft Access.X IN (val1,...valx)orX IN (SELECT val FROM TableOfValuesThatIndicatePrint)either will return true if X is in list of values.Edited by - ValterBorges on 04/28/2003 19:08:55Edited by - ValterBorges on 04/28/2003 19:11:36 |
 |
|
|
|
|
|
help on writing forumula