Another access question here..I'm creating a query using the switch function, but the one I'm creating is too complicated. As a result I'm trying to "translate" it over to a function to run, but I'm not sure how it's down.
This is the query:
Expr1: Switch(InStr([Auto-bw]![Short Description],"sheet")>0,"Sheets, Blankets and Comforters",
InStr([Auto-bw]![Short Description],"blanket")>0,"Sheets, Blankets and Comforters",
InStr([Auto-bw]![Short Description],"comforter")>0,"Sheets, Blankets and Comforters")
Which basically finds certain words in the column and converts it to a more full phrase.
And it goes on for about 20 more rules which Access says is too complicated.
How can I simply turn this into a module?
This is the query:
Expr1: Switch(InStr([Auto-bw]![Short Description],"sheet")>0,"Sheets, Blankets and Comforters",
InStr([Auto-bw]![Short Description],"blanket")>0,"Sheets, Blankets and Comforters",
InStr([Auto-bw]![Short Description],"comforter")>0,"Sheets, Blankets and Comforters")
Which basically finds certain words in the column and converts it to a more full phrase.
And it goes on for about 20 more rules which Access says is too complicated.
How can I simply turn this into a module?
Last edited:
