Update query Criteria help needed

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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
 
to AM append
ToAM: IIF([YourField]="AM",IIF([YourField]="AM/PM",TRUE, FALSE))
To the PM field append
ToPM:IIF([YourField]="PM", IIF([YourField]="AM/PM",TRUE, FALSE))

Evi
 
Back
Top