0(Zero) in query

[Zab]

I have a parameter query that asks for a date range and returns the 7 production lines at my work, the total amount of footage produced from the equipment on each line and the total downtime on that specific line. In my database though, I have times where a line is not selected giving me a zero input (Times when my employees have a scheduled day off, vacation, personal, etc). I need to input these in the database for everything else to function correctly. I run the parameter query and lo and behold all 7 lines come up with the correct calculations, but I get a entry at the top with a zero, zero, and zero in total downtime, total footage, and line worked. How to I make it to where if no line is selected or if no footage is entered, there is no return value in those fields, thus only showing the seven lines vice eight (the ghost 0 line)

Hope this makes sense

Thanks for the help

Frank

 

[Wayne Morgan]

In the criteria for the 2 fields enter

<>0

--
Wayne Morgan
Microsoft Access MVP

I have a parameter query that asks for a date range and returns the 7

production lines at my work, the total amount of footage produced from the
equipment on each line and the total downtime on that specific line. In my
database though, I have times where a line is not selected giving me a zero
input (Times when my employees have a scheduled day off, vacation, personal,
etc). I need to input these in the database for everything else to function
correctly. I run the parameter query and lo and behold all 7 lines come up
with the correct calculations, but I get a entry at the top with a zero,
zero, and zero in total downtime, total footage, and line worked. How to I
make it to where if no line is selected or if no footage is entered, there
is no return value in those fields, thus only showing the seven lines vice
eight (the ghost 0 line).

 

[Cornish Teeth]

Thanks for the help. I feel quite idiotic for something that simple......