Table Entries

10 pts.
Tags:
tables
Why doesn't all my table entries show on my report. Example: I have 100 cases (investigations) entered in my table, but when I run a report it only shows 89. Why does the other entries not show? I designed my query and I enter a "Begin Date" and "End Date" If I run it for the year, it only shows 89. Please help!

Software/Hardware used:
Windows 7
ASKED: July 18, 2013  6:25 PM
UPDATED: July 18, 2013  6:27 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    It sounds like you are working in ACCESS. I would guess that the other 11 have dates outside the range. Try sorting the table on date.. check the dates on the top and bottom of the set, you may find the 11 missing rows.
    48,595 pointsBadges:
    report
  • tlsanders1
    Or sometimes, it might be other items in the join query.  For example, if the join query includes the address of the investigator, but some records don't have an address listed, those records won't show up in the query and therefore won't show up in the table.
    1,340 pointsBadges:
    report
  • JohnKennedy
    I guess something is wrong with two Dates. May be keyed in Begin date Or End date was not correctly type.Pls check try to sort records in ascending and also descending order meanwhile scrutinise the dates carefully. You can try with one parameter at a times, that is, begin Date and End date. When you add another parameter it might contribute to such discrepancy
    415 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following