query problem

  • Thread starter Thread starter natei6
  • Start date Start date
N

natei6

Hi.

In Sheet 1 I have a parts list I Call G1S. There are 53 parts liste
in G1S, Four Columns: Length,Width,Quanity,Description. When I Run
query for all parts with quanities greater than 0, it produces all th
rows requested, but it leaves the quanity column blank, unless all row
in sheet one are full, but if some are blank, it leaves all th
quanities empty. What am I doing wrong?

All the Best

Nathan Sargean
 
Hi
I'm continuing to play with this and it works part of the time, but no
all the time. Almost seem mysterious.

Nathan Sargean
 
Hi,

When I refresh data I only get the Length, Width, And Reference; n
quanity. Here is a copy of my SQL does anyone see a problem.

I all or most quanities are greater than 1, all quanities are visible
when most quanities are blank, I get no quanity at all.

SELECT DISTINCT Good_One_Side.LENGTH, Good_One_Side.WIDTH
Good_One_Side.QTY, Good_One_Side.REFERENCE
FROM Good_One_Side Good_One_Side
GROUP BY Good_One_Side.LENGTH, Good_One_Side.WIDTH, Good_One_Side.QTY
Good_One_Side.REFERENCE
HAVING (Good_One_Side.QTY Is Not Null)
ORDER BY Good_One_Side.LENGTH DESC, Good_One_Side.WIDTH DESC


Any help appreciated

Nathan Sargean
 
Back
Top