Report does not reflect new records entered

[SafetyIntern]

Please bear with me, I am VERY new to access. This has to be in plain
english, talking with the codes completely confuses me.

Here is my problem. I have set up a very simple database to tracking safety
issues. I have my forms and queries set up. We would like to run a report
of all items entered into the database. This was running fine until the last
few records were entered. When I run the query, it will show all 78 records;
however, when I run the report linked to that query it only shows 66, it does
not pull the 12 new records I entered.

Thank you in advance for helping

 

[Jeff Boyce]

A common approach to reports is basing them on queries. Is your report
(that's only showing 66 records) based on the query (that shows 78 records)?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Carl Rapson]

Please bear with me, I am VERY new to access. This has to be in plain
english, talking with the codes completely confuses me.

Here is my problem. I have set up a very simple database to tracking
safety
issues. I have my forms and queries set up. We would like to run a
report
of all items entered into the database. This was running fine until the
last
few records were entered. When I run the query, it will show all 78
records;
however, when I run the report linked to that query it only shows 66, it
does
not pull the 12 new records I entered.

Thank you in advance for helping

Check to see if there is something in the report's Filter property. If so,
clear it and try again. Check the report's Record Source property and make
sure there's nothing there that would limit the records being returned (is
it just the name of the query or is it an SQL statement using the query?).
Lastly, check the query itself to make sure there's nothing that would limit
the records being returned.

Carl Rapson

 

[SafetyIntern]

When I open the query it will show all 78 records, but when I open the
report, I only have 66 showing on the report

 

[Jeff Boyce]

Let me re-state my previous response. Open your report in design view, set
the 'source' for the report to the query that works.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[SafetyIntern]

I've done that, plus tried as Carl suggested and made sure that there was no
filter. Both were set as you all have suggested. I have even tried to make
a new report from the query to see if that works. The new report brings up
the orignal 66 records. Do you think that it is in the query itself?

 

[Jeff Boyce]

Please post the SQL statement of the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[SafetyIntern]

I got this by going to view, SQL view off of the query (not sure if this was
correct), this is what it shows
SELECT NewProjectTable.[Tracking#], NewProjectTable.ItemToBeCorrected,
NewProjectTable.DateReported, NewProjectTable.AreaOfIssue,
NewProjectTable.Machine, NewProjectTable.Block,
NewProjectTable.ReasonReported, *
FROM NewProjectTable;

I hope this is what you were asking for.

THANK YOU so much for helping me, the gentleman at work that is very
proficient in Access is gone to Japan for business, so I can't bug him. You
help is greatly appreciated

 

[Jeff Boyce]

The SQL statement (SQL view off the query) seems to be duplicating the
fields, or at least some of them. Why do you have the "*" in there? Are
there fields you want to see that are not explicitly mentioned in the
statement?

What happens if you delete the ", *" from the SQL view then run it?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I got this by going to view, SQL view off of the query (not sure if this
was
correct), this is what it shows
SELECT NewProjectTable.[Tracking#], NewProjectTable.ItemToBeCorrected,
NewProjectTable.DateReported, NewProjectTable.AreaOfIssue,
NewProjectTable.Machine, NewProjectTable.Block,
NewProjectTable.ReasonReported, *
FROM NewProjectTable;

I hope this is what you were asking for.

THANK YOU so much for helping me, the gentleman at work that is very
proficient in Access is gone to Japan for business, so I can't bug him.
You
help is greatly appreciated

Please post the SQL statement of the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP