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.
Novice
Windows 7 
Access 2010 (version 14.0)
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.
MS MVP - Access Expert
Windows 7 Access 2010 (version 14.0)
Please previous a link to the previous post.
Boyd Trimmell aka Hitechcoach
Database Architect and Problem Solver
Microsoft MVP - Access Expert
25+ years specializing in Accounting, Inventory, and CRM systems
"If technology doesn't work for people, then it doesn't work."
Novice
Windows 7 Access 2010 (version 14.0)
Competent Performer
Windows XP Access 2007
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.
Competent Performer
Windows XP Access 2007
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:
Posting Permissions
Reply With Quote