I'm having an issue with the results of a query and trying to get those results to show on a report. I have a table with the following structure: SType - Text Number - Number Owner - Text Area - Text RType - Text LastWeek - Number Connect - Number Terminate - Number Backdated - Number ThisWeek - Number An example of the data is as follows: SType Number Owner Area RType LastWeek Connect Terminate Backdated ThisWeek C 1 T Dawson City DFGOV 0 0 0 0 0 C 1 S Dawson City DPGOV 0 0 0 4 0 C 1 R Dawson City DRES 0 3 1 0 0 C 1 U Dawson City DDLR 0 0 0 0 0 C 1 Q Dawson City DBUS 0 2 0 0 0 c 2 Q Haines Jct DRES 0 2 1 1 0 There's a total of 25 rows in the table with 5 distinct areas, Dawson City, Haines Jct, Old Crow, Watson Lk, Whitehorse that follow the above mentioned pattern. When I run the following query: SELECT [Latitude ActiveOwner].Area FROM [Latitude ActiveOwner] GROUP BY [Latitude ActiveOwner].Area; I get 5 rows of results, one for each area. When I try to base a report on this query, the report only shows Haines Jct and Old Crow and I can't seem to figure out why. Any ideas?