Report does not return all the data?

[Wrecker]

I have a report built from a table Query. When I look at the table, I have data from dates 7/01 to 10/07. When I run the report it only returns data from 7/01 to 7/17. When I created the report I did not specify group by month.
Any Suggestions on how to fix the problem would be greatly appreciated.

Thanks
Wrecker

 

[SgtJarrow]

Take a look at the data type and formats....

This is where your mistake is going to be.....

If you are storing a "Date/Time", you are going to have to play with the Format some to get the report (query) to display the correct way....

Post your table structure and your query and we can take a closer look... Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[Wrecker]

Same Database I sent you yesterday "4x5 Autobox". I Created a table Query using the "Data" table with date, input, output,and held unit fields. All formats are set to "short date". Then I created the report from the table Query.

Thanks again
Wrecker