By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Recent problem wtih dates in report - Please help

P: n/a
Hello,

I have an Access database that maintains lab result records for a
medical office. There are two linked tables, one that maintains
patient demographics, and the other that links the test results to the
patient. There is only one report, one which displays the most
current and previous test results and graphs them at the bottom of the
page. This has worked perfectly until recently when one of the office
staff noted that all of a sudden the reports contained no data--they
printed totally blank. After some troubleshooting, I discovered that
only dates in August (08/xx/04) and beyond (the future) will print on
the report. Does anybody have any ideas why this is happening?
Thanks for any ideas

Andrew
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
That certainly suggests that some sort of criteria or filter is in place -
but you haven't given us much to go on...

- Turtle

"Andrew" <ap*****@megalink.net> wrote in message
news:da*************************@posting.google.co m...
Hello,

I have an Access database that maintains lab result records for a
medical office. There are two linked tables, one that maintains
patient demographics, and the other that links the test results to the
patient. There is only one report, one which displays the most
current and previous test results and graphs them at the bottom of the
page. This has worked perfectly until recently when one of the office
staff noted that all of a sudden the reports contained no data--they
printed totally blank. After some troubleshooting, I discovered that
only dates in August (08/xx/04) and beyond (the future) will print on
the report. Does anybody have any ideas why this is happening?
Thanks for any ideas

Andrew

Nov 13 '05 #2

P: n/a
Myo
ap*****@megalink.net (Andrew) wrote in message news:<da*************************@posting.google.c om>...
Hello,

I have an Access database that maintains lab result records for a
medical office. There are two linked tables, one that maintains
patient demographics, and the other that links the test results to the
patient. There is only one report, one which displays the most
current and previous test results and graphs them at the bottom of the
page. This has worked perfectly until recently when one of the office
staff noted that all of a sudden the reports contained no data--they
printed totally blank. After some troubleshooting, I discovered that
only dates in August (08/xx/04) and beyond (the future) will print on
the report. Does anybody have any ideas why this is happening?
Thanks for any ideas

Andrew


The date/time format in Access is a complete mess. I've seen that
problem as well. I thought it's a bug, however, it works for US
MM/DD/YYYY. If you set the reginal setting to GB or whatever, change
it back to US setting.. Just giv it try.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.