Update query Criteria help needed

I have a field in my table that is text and has any of these combinations.
AM
PM
AM/PM

I want to run an update query dumping certain fields (Including the Above) into another table.
However
The receiving table has AM and PM Yes No Boxes (2 fields)
So I am guessing I need to put some kind of if statement in the criteria of the Update Query that looks at the text and (If A then AM = 1, if P then PM = 1)
Or something like that - but I can't seem to get the syntax of a correct criteria.

Any help will be appreciated,

Thanks
dave


.

Relevant Pages

  • Re:I Meant Append Query - Sorry
    ... "Dave" wrote in message ... I want to run an update query dumping certain fields into another table. ... The receiving table has AM and PM Yes No Boxes ... Or something like that - but I can't seem to get the syntax of a correct criteria. ...
    (microsoft.public.access.queries)
  • Re: Export to a text file question
    ... it's pretty easy to slap together an UPDATE query that ... >carriage returns. ... >> Dave wrote: ...
    (microsoft.public.access.queries)
  • Re: Update query
    ... UPDATE ExistingTable As E INNER JOIN tblEquivalents as N ... > How do I go about developing an update query to update the same column ... in the first_name column I'd like to update Jon to ... > Jonathan, Ed to Edward, Dave to David, Frank to Franklin, etc. ...
    (microsoft.public.access.queries)
  • Re: Re:I Meant Append Query - Sorry
    ... To the PM field append ... I want to run an update query dumping certain fields (Including the ... So I am guessing I need to put some kind of if statement in the criteria ...
    (microsoft.public.access.queries)