Recent problem wtih dates in report - Please help

[Andrew]

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

[MacDermott]

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

[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.