Access 2016 Web App View allow query null
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?
database-design ms-access view
asked Sep 16 '16 at 12:07
BengelnatzBengelnatz
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.
add a comment |
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?
database-design ms-access view
asked Sep 16 '16 at 12:07
BengelnatzBengelnatz
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.
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
add a comment |
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?
database-design ms-access view
asked Sep 16 '16 at 12:07
BengelnatzBengelnatz
463
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?
database-design ms-access view
database-design ms-access view
asked Sep 16 '16 at 12:07
BengelnatzBengelnatz
463
asked Sep 16 '16 at 12:07
BengelnatzBengelnatz
463
edited Sep 21 '16 at 8:18
Bengelnatz
asked Sep 16 '16 at 12:07
BengelnatzBengelnatz
463
asked Sep 16 '16 at 12:07
BengelnatzBengelnatz
463
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
add a comment |
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
add a comment |
1 Answer
1
active
oldest
votes
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.
answered Sep 20 '16 at 19:30
EricEric
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
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
answered Sep 20 '16 at 19:30
EricEric
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
add a comment |
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.
answered Sep 20 '16 at 19:30
EricEric
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
add a comment |
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.
answered Sep 20 '16 at 19:30
EricEric
1
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.
answered Sep 20 '16 at 19:30
EricEric
1
answered Sep 20 '16 at 19:30
EricEric
1
answered Sep 20 '16 at 19:30
EricEric
1
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
add a comment |
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
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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