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

0 commentaires:

Enregistrer un commentaire

Labels