I want to use excel as a database. I have two workbooks. One that have the vba code and registration, and one that just store the data. When I open up the excel workbook it checks the other workbook and gets the data without open the workbook.
So far so well, but i also wan't to change the data...
I have created a database for books. Where on book can have multiple authors, publishers and translators.
When I create a query all with sum buy for one month. The query is wrong, because when a book have multiple authors, publishers or translators it will sum all, so istedet of 100 i get 300...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.