Hi,
Im sure its possible I just cant fond the syntex. I have a table with positive numbers, negative numbers and zero's in. What I am trying to do is get a query to drop the 0's and convert the negative numbers to positive - any ideas please?
Hi,
Im sure its possible I just cant fond the syntex. I have a table with positive numbers, negative numbers and zero's in. What I am trying to do is get a query to drop the 0's and convert the negative numbers to positive - any ideas please?
Use the Abs() function, and eliminate the 0's with a criteria.
I was just looking at that, which works within the QBE how do I use the abs funtion within VBA? Its the hours I am trying to standardise
And thank you.Code:"TimesheetTable.ID, TimesheetTable.Description, UserNames_tbl.WorksNumber, TimesheetTable.Hours, TimesheetTable.Hours " & _
How are you trying? It would be no different than in the QBE.
Hi,
I think it was a me problem. I used the sql from the QBE and it worked ok - thanks
Happy to help.