Sfrgttk

Square Root Distance from Integers

Is there a verb that means to inject with poison?

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

What language shall they sing in?

Why did the villain in the first Men in Black movie care about Earth's Cockroaches?

Separate environment for personal and development use under macOS

How to visualize the Riemann-Roch theorem from complex analysis or geometric topology considerations?

Bash script to truncate subject line of incoming email

Cat is tipping over bed-side lamps during the night

Hilchos Shabbos English Sefer

Strange "DuckDuckGo dork" takes me to random website

Short story where statues have their heads replaced by those of carved insect heads

Has Britain negotiated with any other countries outside the EU in preparation for the exit?

How to assess the long-term stability of a college as part of a job search

Why does magnet wire need to be insulated?

Why did Democrats in the Senate oppose the Born-Alive Abortion Survivors Protection Act (2019 S.130)?

What is a good reason for every spaceship to carry a weapon on board?

How would an AI self awareness kill switch work?

What is the difference between "...", '...', $'...', and $"..." quotes?

Eww, those bytes are gross

Is there a lava-breathing lizard creature (that could be worshipped by a cult) in 5e?

What makes papers publishable in top-tier journals?

Is a new boolean field better than null reference when a value can be meaningfully absent?

False written accusations not made public - is there law to cover this?

Access 2016 Web App View allow query null

Hide column if any value is null or zero via proc sql or viewbuilding a view w/ fields that only contain a certain wordTable structure/schema for spreadsheet-like web app (ex: Google Docs)?MySql Database solution for specific web app problemDatabase design Problem for the web-appBad performance with select on view if check for 'is null'Access Web App query 3 Tables with aggregatios - Need a workaroundHow can I allow part of a key to be null and enforce uniqueness of records with nulls?How do I get MS Access 2016 to work with SQL Server 2016 where DATETIME columns are involved?

0

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

share|improve this question

edited Sep 21 '16 at 8:18

Bengelnatz

asked Sep 16 '16 at 12:07

BengelnatzBengelnatz

463

bumped to the homepage by Community♦ 7 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 | 

0

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

share|improve this question

edited Sep 21 '16 at 8:18

Bengelnatz

asked Sep 16 '16 at 12:07

BengelnatzBengelnatz

463

bumped to the homepage by Community♦ 7 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

share|improve this question

edited Sep 21 '16 at 8:18

Bengelnatz

asked Sep 16 '16 at 12:07

BengelnatzBengelnatz

463

share|improve this question

edited Sep 21 '16 at 8:18

Bengelnatz

asked Sep 16 '16 at 12:07

BengelnatzBengelnatz

463

share|improve this question

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

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

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
});


}
});

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

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

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 | 

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

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.

share|improve this answer

answered Sep 20 '16 at 19:30

EricEric

1

share|improve this answer

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