LinkBack URL
About LinkBacks
Hi All,
I want to a create column which is based on "Unit location" - Column.
I put this condition: IIf(Left([unit location],3)="RAP",[RAP],[SCO]) but nothing happens and it always ask me to put some Value in one rectangle for RAP and SCO?
How to put Condition in Query column?
Hi All,
I want to a create column which is based on "Unit location" - Column.
I put this condition: IIf(Left([unit location],3)="RAP",[RAP],[SCO]) but nothing happens and it always ask me to put some Value in one rectangle for RAP and SCO?
Perhaps an explanation of what your tables look like and the data within them might be helpful as your expression appears to be properly syntaxed. Also, I don't know that this means.
Please explain this.put some Value in one rectangle for RAP and SCO?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I can't upload .accdb file. Don't know why.
In attachment you can find Excel file so you can export it in Access and try with Query that I described.
In your expression you are referencing two non-existent fields RAP and SCO. That is why you are getting the parameter request.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks