Affichage des articles dont le libellé est Only show entered data. Afficher tous les articles
Affichage des articles dont le libellé est Only show entered data. Afficher tous les articles

Only show entered data

vendredi 3 avril 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;




Only show entered data

Labels