I'm designing an Access 2016 Web App for inventoring our computers.
Here you see the view:
Some of those are queries. The problem is with SSD-Storage and HDD-Storage.
The query looks like that:
and the result:
Problem is that there should be way more PCs, but they aren't shown because for example they have no HDD or SSD so the query is empty. On some I did not put in the motherboard and so on. I set default values for the view-fields.
How can I get the view to show me something like 0 or null for all fields without values?