eliminating pop up boxes asking for a value (part 2)

**REBBROWN** · 10-12-2010, 12:30 PM

see previous post for explanation.

I had hoped to cut and paste query output as text but did not work.
I have included a screen shot in this post.

**HiTechCoach** · 10-13-2010, 10:46 PM

Please previous a link to the previous post.

**REBBROWN** · 10-13-2010, 10:48 PM

**slave138** · 10-14-2010, 04:09 PM

Just guessing, but you should probably focus on this section of the query:

Code:

Count(VEHICLE_MOVEMENT.LOAD_DATE) AS TOTAL_SHIPPED

I'm thinking there probably is something wrong with the bold part.

**slave138** · 10-14-2010, 04:49 PM

My guess was wrong. I was able to get the query to work as described by removing the grouping from TOTAL_IN_YARD. See query screenshot: