Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extra Records with MS Access as data source

Status
Not open for further replies.

pokerace

Technical User
May 24, 2005
118
US
C10

I am trying to add in a table from an Access file as my data source. However, when I try to view the records in Crystal preview, it will list the 200 or so in the access table, and then many blank records after those. The same thing happens in with Excel. It seems as if Crystal is reading all of the blank rows after the data, and inserting those as blank records. What can I do to fix that?
 
Technically you can't add in tables, you cana add in rows from tables, or delete rows, etc.

Try using technical descriptions:

Original data source
How you are adding rows
Example data
Expected output

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top