Donate SIGN UP

iif statement in open office

Avatar Image
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
Gravatar

Answers

1 to 3 of 3rss feed

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.
Open Office is a suite of several programs.
Which one are you using?
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?



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 3rss feed

Do you know the answer?

iif statement in open office

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.