Ask Experts Questions for FREE Help !
Ask
    lebboy's Avatar
    lebboy Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Apr 29, 2003, 09:25 AM
    Update Query in Access
    Hi there! How can I update different records differently in one field based on different criteria? Can I use the update query for that? Do I have to use a macro? Thanks for the help!
    JenVW's Avatar
    JenVW Posts: 1, Reputation: 1
    New Member
    		  
    #2

    Jul 11, 2005, 12:26 PM
    Use a conditional expression :

    IIF(Criteria 1 is true), Criteria 1 response, Criteria 2 response

    Jen
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Crosstab Query in MS Access [ 1 Answers ]

How can I change the my query to crosstab query.. please see the picture.. http://www.l22l.com/l22l-up-1/8a7081adec.jpg I write this code... how can I change to a crosstab query SELECT SeaTable.location, Count(SeaTable.location) AS CountOflocation FROM SSFMainTable INNER JOIN SeaTable...

Tax Query [ 4 Answers ]

If an Indian citizen works for a Canadian company from home in India, is the person eligible for income tax? The salary is wired through the Canadian company.

DNS Query Query. A Query about DNS Queries... [ 12 Answers ]

I am a software developer, I don’t know much about networks. I have a working network but with one weird (well to me it’s weird) problem. If you can offer any insight I’ll be very grateful! <!--- Image Attachment Below (I couldn't find a way to paste it here in the editor :-( ) ---> ...

Run MS access query as exe [ 1 Answers ]

Hi, I have to run few queries one after another. I created a form, so now I can run them in sequence with just 1 click of a button. It there a way that I can start running those queries by just loading the form and not clicking any button. My main aim is to have a schedule task so Access...

View more questions Search