Recent content by daioros

This is ridiculous! Now they don't like Access, they want the same results, but in Excel. Way harder and, if we want it elegant, then impossible. And once a week they will add more users and data. (WTF? Microsoft Access is the right solution!) Sorry and thanks everybody for your time and ideas.

thanks to everybody! If I have a little time this afternoon I'll watch the video, post a example of relationships and report needed.

Normalization! Ha ha ha! That was my first thought. But two weeks ago they gave me this quick task for "yesterday" and couldn't find a quick and elegant solution. And today they gave me another "crappy" Excel tables again. Thanks!

If I can avoid it, no "UserVehicle" table. And no, I cannot show you anything. But assume that relationships are 1:M as usual. thanks.

Thanks for your reply. It's been more than 10 years since my last time with Access, so I couldn't see an easy solution to this. And sorry, I cannot upload any picture due to privacy concerns. But no worries, asume the simplest database ever. But i'm not sure if it can be done that way, because...

EDITED: Changed "Bikes" for "Computers" (to make it clear that data of different tables cannot be mixed). Hi, everyone! Imagine a database with three tables: "Users", "Cars" and "Computers". Which is the easiest way to get only ONE report that shows each user and which cars and computers has...