Hey all. I am sorry if this has been asked before. I did search and everything I have tried has not worked. Here is my issue.
I have created a Database. The database only has 1 table that I have linked to (this table is updated everyday). The table has 2 columns that when we run the report out of our work system, they are negative numbers. I need to make these be Positive numbers when I run the query. I have changed it to show one of the columns as currency so it is putting them in parentheses () because they are negative.
I went into the query, went into design view, chose Update and then tried multiple ways of doing the Update To field, each time it has not worked. For instance, I tried going into the Expression builder and entering Abs([Quantity]*-1), when I do this, if I click back on Select (instead of Update) and then click Run, it still gives me negative numbers. If I leave it on Update and then click run it tells me that the Operation must use an updateable query. Each different way that I have entered it I get the same result.
I feel like I am missing something simple, I just cannot figure out what is happening.