Query/Report question

[efgh]

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?

 

[Guest]

Post your complete SQL.

 

[efgh]

Post your complete SQL.

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?

That is my complete SQL. The SQL statement above is the query that I'm
basing my report from. It's about as simple as I can make it. I feel as
though I'm missing something that's allowing me to see the rest of the rows
in the report that I see in the query results. I should add that I tried to
bind this report to the table that I'm selecting from and I'm seeing rows 6
through 16 instead of rows 1 through 25. I'm stumped.

 

[efgh]

Post your complete SQL.

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?

That is my complete SQL. The SQL statement above is the query that I'm
basing my report from. It's about as simple as I can make it. I feel as
though I'm missing something that's allowing me to see the rest of the
rows in the report that I see in the query results. I should add that I
tried to bind this report to the table that I'm selecting from and I'm
seeing rows 6 through 16 instead of rows 1 through 25. I'm stumped.

I found the issue. I was selecting Layout Preview rather than Print
Preview.