Report not picking up data from an existing Access 2000 Table

  • Thread starter Thread starter Edward Grant
  • Start date Start date
E

Edward Grant

I am testing a database that uses aTabel used to store
information on sales leads. Having created a report to
summarize the lead information for a series of stsff, It
does not connect to the stored data even though the
controls to accomplish this are in place. I've read and
tiried most the things available in "Help' and else where
on the website, they don't seem to be effective. Any
suggestions???
 
Hi Edward,

is it possible that you give us more detailed information how you try to achieve this.
 
The first thing I would check is the RecordSource of the
Report. Open the DatasheetView of the RecordSource by
itself and see if it is the data you want.

If it isn't, you need to fix the RecordSource.

If it is, check the Filter Property of the Report. If you
open the Report by code, check the statement that opens
the Report for Filter or WhereCodition.

Note: If you are in the process of entering the data and
you want to include the new Record / or Record currently
being edited, you need to save it into the Table first
before running the Report.

HTH
Van T. Dinh
MVP (Access)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't create a report from my query in Access 1
LookUp in macro? - Access 2003 2
Data shown in table 5
Access Report question 1
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
A Filtered Summary Report 2
Pull data from existing entries for a drop down box 2
Retrieve data from flatfile to table plus auto update table and re 5

Back
Top