Recent content by GiannisGalatsis

Thanks a lot, I was use an update query to remove the last 5 digit, the number of code ( I was find this there: "access-programmers.co.uk/forums/showthread.php?t=166486" ). I don't need it and then I use your query and it work. :):):)

this excel is th export file from a software for receipt

Thanks for sesponding For examble the excel file is like this table: Code | Title | Quantity | Price Publisher1.00001 | 50 shades of grey | 5 | 15 € Publisher2.00132 | The island | 1 | 13 € Publisher1.00044 | Mr. Mercendes |3 | 9 € Publisher3.00044 |...

Hi, I want to set the totals of many queries into one report I have an ecxel for the total selling of books of a bookshop(per month). I was import the excel to access into a table. The books are from about 30 differend publishers. The records from the selling have the fields code, title...