Records missing in a query

[Teri]

I have 121 records in a Table called survey. When I run a Query, only 118
records display. What am I doing wrong? I have no filters applied.

 

[Duane Hookom]

Do you mind sharing the SQL view of your query?

 

[Teri]

I'm pretty much a newbie, would you please tell me how to do this?

 

[Teri]

I figured it out:

SELECT Survey.SurveyID, Survey.[37], Survey.[38]
FROM Survey;

 

[Teri]

SELECT Survey.SurveyID, Survey.[37], Survey.[38]
FROM Survey;

 

[Duane Hookom]

I would right-click in the datasheet view and select "Display all Records".
Also check your table records to make sure your expected total number of
records is correct.

--
Duane Hookom
MS Access MVP

SELECT Survey.SurveyID, Survey.[37], Survey.[38]
FROM Survey;

Do you mind sharing the SQL view of your query?

 

[Teri]

Okay, I should have been more clear. ALL the records show in the query's
datasheet view. Only 118 of the records show in the Report that I create
using Auto Report right out of the query! It just doesn't make any sense...

I would right-click in the datasheet view and select "Display all Records".
Also check your table records to make sure your expected total number of
records is correct.

--
Duane Hookom
MS Access MVP

SELECT Survey.SurveyID, Survey.[37], Survey.[38]
FROM Survey;

Do you mind sharing the SQL view of your query?

--
Duane Hookom
MS Access MVP


I have 121 records in a Table called survey. When I run a Query, only
118
records display. What am I doing wrong? I have no filters applied.

 

[Duane Hookom]

Add a text box to the Report Header or Footer with a control source of:
=Count(*)
What do you get for a value?

--
Duane Hookom
MS Access MVP

Okay, I should have been more clear. ALL the records show in the query's
datasheet view. Only 118 of the records show in the Report that I create
using Auto Report right out of the query! It just doesn't make any
sense...

I would right-click in the datasheet view and select "Display all
Records".
Also check your table records to make sure your expected total number of
records is correct.

--
Duane Hookom
MS Access MVP

SELECT Survey.SurveyID, Survey.[37], Survey.[38]
FROM Survey;


:

Do you mind sharing the SQL view of your query?

--
Duane Hookom
MS Access MVP


I have 121 records in a Table called survey. When I run a Query,
only
118
records display. What am I doing wrong? I have no filters applied.

 

[Teri]

I get 121! But only records through 118 are printing! What could possibly
be wrong?

Add a text box to the Report Header or Footer with a control source of:
=Count(*)
What do you get for a value?

--
Duane Hookom
MS Access MVP

Okay, I should have been more clear. ALL the records show in the query's
datasheet view. Only 118 of the records show in the Report that I create
using Auto Report right out of the query! It just doesn't make any
sense...

I would right-click in the datasheet view and select "Display all
Records".
Also check your table records to make sure your expected total number of
records is correct.

--
Duane Hookom
MS Access MVP


SELECT Survey.SurveyID, Survey.[37], Survey.[38]
FROM Survey;


:

Do you mind sharing the SQL view of your query?

--
Duane Hookom
MS Access MVP


I have 121 records in a Table called survey. When I run a Query,
only
118
records display. What am I doing wrong? I have no filters applied.

 

[Duane Hookom]

Add a text box in your detail section with a control source of
=1
Set its Running Sum property to Over All.

Run it and read it.

--
Duane Hookom
MS Access MVP
--

I get 121! But only records through 118 are printing! What could possibly
be wrong?

Add a text box to the Report Header or Footer with a control source of:
=Count(*)
What do you get for a value?

--
Duane Hookom
MS Access MVP

Okay, I should have been more clear. ALL the records show in the
query's
datasheet view. Only 118 of the records show in the Report that I
create
using Auto Report right out of the query! It just doesn't make any
sense...

:

I would right-click in the datasheet view and select "Display all
Records".
Also check your table records to make sure your expected total number
of
records is correct.

--
Duane Hookom
MS Access MVP


SELECT Survey.SurveyID, Survey.[37], Survey.[38]
FROM Survey;


:

Do you mind sharing the SQL view of your query?

--
Duane Hookom
MS Access MVP


I have 121 records in a Table called survey. When I run a Query,
only
118
records display. What am I doing wrong? I have no filters
applied.

 

[Teri]

Duane, that number is showing 121. I'm only seeing records for 118; I know
what I should be seeing on the report and those are missing. I really don't
have the time to spend on trying to figure this stupid thing out, so I
created a Pivot Table from the query and exported that to Excel. All the
records show that way. Thanks again for all your efforts!

Add a text box in your detail section with a control source of
=1
Set its Running Sum property to Over All.

Run it and read it.

--
Duane Hookom
MS Access MVP
--

I get 121! But only records through 118 are printing! What could possibly
be wrong?

Add a text box to the Report Header or Footer with a control source of:
=Count(*)
What do you get for a value?

--
Duane Hookom
MS Access MVP


Okay, I should have been more clear. ALL the records show in the
query's
datasheet view. Only 118 of the records show in the Report that I
create
using Auto Report right out of the query! It just doesn't make any
sense...

:

I would right-click in the datasheet view and select "Display all
Records".
Also check your table records to make sure your expected total number
of
records is correct.

--
Duane Hookom
MS Access MVP


SELECT Survey.SurveyID, Survey.[37], Survey.[38]
FROM Survey;


:

Do you mind sharing the SQL view of your query?

--
Duane Hookom
MS Access MVP


I have 121 records in a Table called survey. When I run a Query,
only
118
records display. What am I doing wrong? I have no filters
applied.

 

[Duane Hookom]

"that number is showing 121" doesn't make sense because you should be
seeing:
1
2
3
....
121
in the detail section.

--
Duane Hookom
MS Access MVP
--

Duane, that number is showing 121. I'm only seeing records for 118; I
know
what I should be seeing on the report and those are missing. I really
don't
have the time to spend on trying to figure this stupid thing out, so I
created a Pivot Table from the query and exported that to Excel. All the
records show that way. Thanks again for all your efforts!

Add a text box in your detail section with a control source of
=1
Set its Running Sum property to Over All.

Run it and read it.

--
Duane Hookom
MS Access MVP
--

I get 121! But only records through 118 are printing! What could
possibly
be wrong?


:

Add a text box to the Report Header or Footer with a control source
of:
=Count(*)
What do you get for a value?

--
Duane Hookom
MS Access MVP


Okay, I should have been more clear. ALL the records show in the
query's
datasheet view. Only 118 of the records show in the Report that I
create
using Auto Report right out of the query! It just doesn't make any
sense...

:

I would right-click in the datasheet view and select "Display all
Records".
Also check your table records to make sure your expected total
number
of
records is correct.

--
Duane Hookom
MS Access MVP


SELECT Survey.SurveyID, Survey.[37], Survey.[38]
FROM Survey;


:

Do you mind sharing the SQL view of your query?

--
Duane Hookom
MS Access MVP


I have 121 records in a Table called survey. When I run a
Query,
only
118
records display. What am I doing wrong? I have no filters
applied.

 

[Teri]

The total is 121. I do see 1, 2, 3, etc. The last number is 121, however
the SurveyID number is 118. Plus, I'm not seeing the data for 119, 120, and
121. I just don't understand it....

"that number is showing 121" doesn't make sense because you should be
seeing:
1
2
3
....
121
in the detail section.

--
Duane Hookom
MS Access MVP
--

Duane, that number is showing 121. I'm only seeing records for 118; I
know
what I should be seeing on the report and those are missing. I really
don't
have the time to spend on trying to figure this stupid thing out, so I
created a Pivot Table from the query and exported that to Excel. All the
records show that way. Thanks again for all your efforts!

Add a text box in your detail section with a control source of
=1
Set its Running Sum property to Over All.

Run it and read it.

--
Duane Hookom
MS Access MVP
--

I get 121! But only records through 118 are printing! What could
possibly
be wrong?


:

Add a text box to the Report Header or Footer with a control source
of:
=Count(*)
What do you get for a value?

--
Duane Hookom
MS Access MVP


Okay, I should have been more clear. ALL the records show in the
query's
datasheet view. Only 118 of the records show in the Report that I
create
using Auto Report right out of the query! It just doesn't make any
sense...

:

I would right-click in the datasheet view and select "Display all
Records".
Also check your table records to make sure your expected total
number
of
records is correct.

--
Duane Hookom
MS Access MVP


SELECT Survey.SurveyID, Survey.[37], Survey.[38]
FROM Survey;


:

Do you mind sharing the SQL view of your query?

--
Duane Hookom
MS Access MVP


I have 121 records in a Table called survey. When I run a
Query,
only
118
records display. What am I doing wrong? I have no filters
applied.

 

[Duane Hookom]

What do you mean by "last number is 121" and yet you are "not seeing the
data for" 121?
Is there actually the number 121 in the detail section? If so, what aren't
you seeing?
What does the SurveyID have to do with the number of records that are
displaying?
Is there only one table in your report's record source?

--
Duane Hookom
MS Access MVP
--

The total is 121. I do see 1, 2, 3, etc. The last number is 121, however
the SurveyID number is 118. Plus, I'm not seeing the data for 119, 120,
and
121. I just don't understand it....

"that number is showing 121" doesn't make sense because you should be
seeing:
1
2
3
....
121
in the detail section.

--
Duane Hookom
MS Access MVP
--

Duane, that number is showing 121. I'm only seeing records for 118; I
know
what I should be seeing on the report and those are missing. I really
don't
have the time to spend on trying to figure this stupid thing out, so I
created a Pivot Table from the query and exported that to Excel. All
the
records show that way. Thanks again for all your efforts!

:

Add a text box in your detail section with a control source of
=1
Set its Running Sum property to Over All.

Run it and read it.

--
Duane Hookom
MS Access MVP
--

I get 121! But only records through 118 are printing! What could
possibly
be wrong?


:

Add a text box to the Report Header or Footer with a control source
of:
=Count(*)
What do you get for a value?

--
Duane Hookom
MS Access MVP


Okay, I should have been more clear. ALL the records show in the
query's
datasheet view. Only 118 of the records show in the Report that
I
create
using Auto Report right out of the query! It just doesn't make
any
sense...

:

I would right-click in the datasheet view and select "Display
all
Records".
Also check your table records to make sure your expected total
number
of
records is correct.

--
Duane Hookom
MS Access MVP


SELECT Survey.SurveyID, Survey.[37], Survey.[38]
FROM Survey;


:

Do you mind sharing the SQL view of your query?

--
Duane Hookom
MS Access MVP


I have 121 records in a Table called survey. When I run a
Query,
only
118
records display. What am I doing wrong? I have no filters
applied.