Search results

More Thanks Sorry, just my keyboard dyslexia i do have the brackets in the right place in my statement :)

Thanks Thanks for the reply all, still having problems, the tables are on an old AS400 system so i have no control over them they are just linked to my database. What you have come up with is what i have done but it still don't work. Please see actual pasted below...

Hi guys, I have a query that is trying to calculate a tax amount based on invoice value, but is variable depending on a customer tax code. So if a customer has tax code A,( this info is stored in the customer table) then tax is 17.5%, if tax code is X then it is zero but i still need to show...

Thanks guys both worked a treat, can go on holiday and relax thanks to you. :)

Hi, i have a linked table where the date is stored as a number, can't change the format as it's an export file from an old system. The date is held thus: 20040629, for the 29th June 2004. I need to change this to a usable date to enable me to perform days since calculations. i am sort of half...