Only show entered data (1 Viewer)

Infinite · Apr 3, 2015

Hello there! I have a problem, I have 4 columsn, numbers 1 is ModelID, 2 is FitPerSheet, 3s NeedCutOut and 4 is Time: [NeedCutOut]/[FitperSheet]

Thing is, I only enter some numbers into NeedCutOut, and I dont want to see any of the Models that I dont have a NeedCutOut number for. How would I go about doing that? Thanks!

here is the SQL code just in case. Never know.

Code:

SELECT tblPerSheetTime.ModelID, 
tblPerSheetTime.FitPerSheet, tblPerSheetTime.NeedCutOut, [NeedCutOut]/[FitperSheet] AS [Time], *
FROM tblPerSheetTime;

pbaldy · Apr 3, 2015

Try

SELECT tblPerSheetTime.ModelID,
tblPerSheetTime.FitPerSheet, tblPerSheetTime.NeedCutOut, [NeedCutOut]/[FitperSheet] AS [Time], *
FROM tblPerSheetTime
WHERE NeedCutOut Is Null

Infinite · Apr 3, 2015

ok, think you might have messed up, I dont see any of the models that I entered a NeeCutOut for.

pbaldy · Apr 3, 2015

Can you post the db here? That should display all records where the NeedCutOut field is Null.

Infinite · Apr 3, 2015

here ya go.

pbaldy · Apr 3, 2015

Which records are you expecting to see/exclude? The SQL I gave you only shows records where NeedCutOut is Null, as expected.

Infinite · Apr 3, 2015

ok, I only want records that have a NeedCutOut number.

pbaldy · Apr 3, 2015

Try

SELECT tblPerSheetTime.ModelID,
tblPerSheetTime.FitPerSheet, tblPerSheetTime.NeedCutOut, [NeedCutOut]/[FitperSheet] AS [Time], *
FROM tblPerSheetTime
WHERE NeedCutOut Is Not Null

Infinite · Apr 3, 2015

Thanks man! Worked like a charm!

pbaldy · Apr 3, 2015

No problem. I think I got thrown off by the double negative.

Only show entered data (1 Viewer)

Infinite

More left to learn.

pbaldy

Wino Moderator

Infinite

More left to learn.

pbaldy

Wino Moderator

Infinite

More left to learn.

pbaldy

Wino Moderator

Infinite

More left to learn.

pbaldy

Wino Moderator

Infinite

More left to learn.

pbaldy

Wino Moderator

Similar threads

Users who are viewing this thread