Snippets home page
 
 
register
 
 
computer

How do you use the if then squery in access?

I do not understand how to make this work in access.

asked by pappu (168)

You have 50 words left!
 
 
related questions

What is the process for counting and grouping data with access?

How do I access the radio buttons on Microsoft access?

How do I use Access using substr in a query?

In MS Access how do you show value in field while referring to index value ?

What can you tell me about having multiple criteria in dsum in MS Access?

What does the type mismatch in expression error mean when using Access?

Who can access adoption records?

Tags:  computer  software

answers

IF-THEN is a process in which the condition defines like,IF the condition given from you is right one then it accept and the THEN continue the other process.

7 votes

In order to use the microsoft access query you need to have a variable (for instance, x) and something to compare it to (let's say, 20) So: If x > 20; Print "hello World! " Also, Google your answers.

reply
posted by MrMoth (34)
6 votes

The keyword is called IIF. The schema is like this: IIF([field1]="nok", "not ok", [field1]). If there is already a yes/no field you can write: IIF([field1], "new text", [field1]).

reply
posted by gigo (648)
3 votes

Report a post on this page as inappropriate
 If you have questions about user content, read our liability disclaimer

  
   
Add your own answer in 50 words or less! Add your comment in 50 words or less!

copyright © 2008
conjecture corporation

FAQ About Us Contact Us Terms & Conditions Privacy Policy