aparker@megalink.net (Andrew) wrote in message news:<da4bd1a3.0408200531.b3eae2b@posting.google.c om>...[color=blue]
> 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[/color]
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.
