X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Update One Field Based On Multiple Criteria In One Query, Access 2007    
post Nov 11 2019, 03:44 PM

Posts: 397
Joined: 27-June 08

I got it working in Excel and never had trouble with this until now. Something I am not seeing

I have a field (text) has a total charge and the Tip of that charge show up on another row. Same field though.

I wrote an IIF statement as such (IIF("[transaction amount] <5",'TIP','FARE')) . I did not think of needing to put this in an update query, or a case statement. This worked well in Excel !!

See attached it is assigning label incorrectly i.e. : Fare is labeled as TIP and vice versa

I would like to see a few options to do this .I would appreciate some code examples also



Attached File(s)
Attached File  TipTable.JPG ( 16.03K )Number of downloads: 0
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    10th April 2020 - 03:08 PM