Selection of one value from a database field(containing more than one data)??

[#1]

Hi All,

I want to put some condition like the sheet should be hidden with respect to one of the data coming from my Location_name field. Currently this feild returning 3 datas.

if(LOCATION_NAME = 'BIDA' or QVUSER()='ADMIN',1,0)

But when i am putting condition as above its not working for me.

I dont know basically but what i mean to say here is that how my location name should compare with all the data and when it matches with 'BIDA' it should work for me.

Could anyone please help me on this?

Thanks,

Mahasweta

[#2]

Hi Mahasweta,

Here you are a possible solution, I hope it will be what are you looking for.

The administrator user / pass: ADMIN / ADMIN

The user who can't see the hidden sheet is: 1/1 there are other users with access.

Best regards.