Forum Discussion
Relationship with Dates
GilesWalker i'm unable to see the bottom from data view or query view as it's too many rows.
I am no expert, in fact I ask for a lot of help on here, but from my expierence I learned to start in excel by formatting the data as a table with headers. Once that is done you can quickly scroll to the bottom of the table using the slide bar on the right. I have tables with 90,000 rows and can get to the bottom in seconds this way.
Once you do that you might find you have blank rows on your table. That happened to me and it took me 2 days to realize that was the problem. Find Duplicates does not count blank rows so it will not appear as a problem. Delete those blank rows so your table is completely filled in, then refresh data and import it back in again.
Hope that helps! Goodluck,
HW