Access 2016 Web App View allow query null












0















I'm designing an Access 2016 Web App for inventoring our computers.



Here you see the view:



View



Overview_Query



Some of those are queries. The problem is with SSD-Storage and HDD-Storage.



The query looks like that:



Query



and the result:
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?










share|improve this question
















bumped to the homepage by Community 2 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.











  • 1





    You need a left join, an immediate if and an isnull function. Post a formatted SQL statement for a proper answer.

    – byrdzeye
    Sep 16 '16 at 13:46











  • there is no such thing in access web apps (afaik). The query aboth is all I have for that.

    – Bengelnatz
    Sep 16 '16 at 14:12
















0















I'm designing an Access 2016 Web App for inventoring our computers.



Here you see the view:



View



Overview_Query



Some of those are queries. The problem is with SSD-Storage and HDD-Storage.



The query looks like that:



Query



and the result:
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?










share|improve this question
















bumped to the homepage by Community 2 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.











  • 1





    You need a left join, an immediate if and an isnull function. Post a formatted SQL statement for a proper answer.

    – byrdzeye
    Sep 16 '16 at 13:46











  • there is no such thing in access web apps (afaik). The query aboth is all I have for that.

    – Bengelnatz
    Sep 16 '16 at 14:12














0












0








0








I'm designing an Access 2016 Web App for inventoring our computers.



Here you see the view:



View



Overview_Query



Some of those are queries. The problem is with SSD-Storage and HDD-Storage.



The query looks like that:



Query



and the result:
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?










share|improve this question
















I'm designing an Access 2016 Web App for inventoring our computers.



Here you see the view:



View



Overview_Query



Some of those are queries. The problem is with SSD-Storage and HDD-Storage.



The query looks like that:



Query



and the result:
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?







database-design ms-access view






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Sep 21 '16 at 8:18







Bengelnatz

















asked Sep 16 '16 at 12:07









BengelnatzBengelnatz

463




463





bumped to the homepage by Community 2 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.







bumped to the homepage by Community 2 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.










  • 1





    You need a left join, an immediate if and an isnull function. Post a formatted SQL statement for a proper answer.

    – byrdzeye
    Sep 16 '16 at 13:46











  • there is no such thing in access web apps (afaik). The query aboth is all I have for that.

    – Bengelnatz
    Sep 16 '16 at 14:12














  • 1





    You need a left join, an immediate if and an isnull function. Post a formatted SQL statement for a proper answer.

    – byrdzeye
    Sep 16 '16 at 13:46











  • there is no such thing in access web apps (afaik). The query aboth is all I have for that.

    – Bengelnatz
    Sep 16 '16 at 14:12








1




1





You need a left join, an immediate if and an isnull function. Post a formatted SQL statement for a proper answer.

– byrdzeye
Sep 16 '16 at 13:46





You need a left join, an immediate if and an isnull function. Post a formatted SQL statement for a proper answer.

– byrdzeye
Sep 16 '16 at 13:46













there is no such thing in access web apps (afaik). The query aboth is all I have for that.

– Bengelnatz
Sep 16 '16 at 14:12





there is no such thing in access web apps (afaik). The query aboth is all I have for that.

– Bengelnatz
Sep 16 '16 at 14:12










1 Answer
1






active

oldest

votes


















0














Warning, I am also quite new to the Access Web App, so this might not work/you may have already tried it.



Could you add in a ">0 Or Is Null" criteria (or something similar) to the HDD and SDD fields?



It might help if you gave us more details about the specifics of your tables, especially which [TABLE].[FIELD]s are related to which.






share|improve this answer
























  • I added the query for the view where you can see the relationships. Wouldn't a criteria just return less values? I want more. Tried loads of IIFs but I'm completly stuck,

    – Bengelnatz
    Sep 21 '16 at 8:20











Your Answer








StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f149893%2faccess-2016-web-app-view-allow-query-null%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









0














Warning, I am also quite new to the Access Web App, so this might not work/you may have already tried it.



Could you add in a ">0 Or Is Null" criteria (or something similar) to the HDD and SDD fields?



It might help if you gave us more details about the specifics of your tables, especially which [TABLE].[FIELD]s are related to which.






share|improve this answer
























  • I added the query for the view where you can see the relationships. Wouldn't a criteria just return less values? I want more. Tried loads of IIFs but I'm completly stuck,

    – Bengelnatz
    Sep 21 '16 at 8:20
















0














Warning, I am also quite new to the Access Web App, so this might not work/you may have already tried it.



Could you add in a ">0 Or Is Null" criteria (or something similar) to the HDD and SDD fields?



It might help if you gave us more details about the specifics of your tables, especially which [TABLE].[FIELD]s are related to which.






share|improve this answer
























  • I added the query for the view where you can see the relationships. Wouldn't a criteria just return less values? I want more. Tried loads of IIFs but I'm completly stuck,

    – Bengelnatz
    Sep 21 '16 at 8:20














0












0








0







Warning, I am also quite new to the Access Web App, so this might not work/you may have already tried it.



Could you add in a ">0 Or Is Null" criteria (or something similar) to the HDD and SDD fields?



It might help if you gave us more details about the specifics of your tables, especially which [TABLE].[FIELD]s are related to which.






share|improve this answer













Warning, I am also quite new to the Access Web App, so this might not work/you may have already tried it.



Could you add in a ">0 Or Is Null" criteria (or something similar) to the HDD and SDD fields?



It might help if you gave us more details about the specifics of your tables, especially which [TABLE].[FIELD]s are related to which.







share|improve this answer












share|improve this answer



share|improve this answer










answered Sep 20 '16 at 19:30









EricEric

1




1













  • I added the query for the view where you can see the relationships. Wouldn't a criteria just return less values? I want more. Tried loads of IIFs but I'm completly stuck,

    – Bengelnatz
    Sep 21 '16 at 8:20



















  • I added the query for the view where you can see the relationships. Wouldn't a criteria just return less values? I want more. Tried loads of IIFs but I'm completly stuck,

    – Bengelnatz
    Sep 21 '16 at 8:20

















I added the query for the view where you can see the relationships. Wouldn't a criteria just return less values? I want more. Tried loads of IIFs but I'm completly stuck,

– Bengelnatz
Sep 21 '16 at 8:20





I added the query for the view where you can see the relationships. Wouldn't a criteria just return less values? I want more. Tried loads of IIFs but I'm completly stuck,

– Bengelnatz
Sep 21 '16 at 8:20


















draft saved

draft discarded




















































Thanks for contributing an answer to Database Administrators Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f149893%2faccess-2016-web-app-view-allow-query-null%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Liste der Baudenkmale in Friedland (Mecklenburg)

Single-Malt-Whisky

Czorneboh