iif statement in open office

may-c | 08:41 Fri 08th Aug 2008 | Technology

3 Answers

why do i get a message access is denied when i use the iif statement in a query?

how do i do that? i want to assign a specific value for a certain input

memory stick/usb flash drive ect

Sky +/HD boxes

Answers

1 to 3 of 3

Best Answer

No best answer has yet been selected by may-c. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

gen2

Open Office is a suite of several programs.
Which one are you using?

kujawski

i be guessing its MS access

the format is:

iif([myfield]='Hello','Display Hello','Goodbye')

other then that, ???

are you running the query against an attached table, from say an SQl database, which you need to loginto first?

may-c

Question Author

its open office.org base (2.4)

my syntax is correct as how u have written but i get the message 'acces is denied' when running the query.

This works in MS Access but i cant get it to work on open office base

1 to 3 of 3

Do you know the answer?