Novice
Windows XP 
Access 2007
Within my database I have a report (BusStopsByRoute), and, somehow it is displaying only portions of a query that retrieves rows. Initially one would think that there is a problem with the relationships however, a separate query returns data correctly, hence, the problem is thought to be an issue with the report itself.
Attachment includes screenshot and SQL query.
Database is available at https://skydrive.live.com/embed?cid=...O8Y13CuRuXLx2k.
VIP
Windows XP Access 2010 32bit
The report should show the same results as query BusStopsPerRoute? I pasted this query's SQL into the report's RecordSource and the results appear to agree.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Query on multiple rows
Filtering out rows based on values in other rows
Query using all rows of a list box
Query only certain rows?
Posting Permissions
Reply With Quote