Re: Calculating Difference In Time For Age

Actually my problem is probably that I have not done anything with Doug's
code listed in the article.

Knowing that one of the Ten Commandments for Access users is to "Never Use
Code" that you don't understand, and since I do not even know what to do with
it (I might guess that I paste it into a new module and name the module
Diff2Dates), I guess I am just going to be out of luck with this report I am
creating.

What I have is software which will print a report to a txt file of all the
tests for the quarter (about 4000). Excel nicely opens this, I save it and
then I import the data into an Access table. From there I can do alot of
what I need, but I need the age of the neonate too, and I have found that the
date and time for the two fields is imported as text, which I lose when I
change the field design to Date/Time.

"Allen Browne" wrote:

> Access does not have a function to do that, but MVP Doug Steele has one
> here:
> http://www.accessmvp.com/djsteele/Diff2Dates.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Jeff C" <JeffC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:243494B0-75DA-439E-95C1-C9A6D45CD299@xxxxxxxxxxxxxxxx
> >I am working on a report for a neonatal unit which requires the specific
> >age
> > of the newborns through a series of tests. I have two fields each holding
> > a
> > date and time, one field for the birth date and time...the second for the
> > test date and time. They are formated as such: 7/10/2005 15:35.
> >
> > Can someone help me with a formula I can use as the control source of a
> > text
> > box in my report that will return the difference (age) in days, hours, and
> > minutes? Thank You.
>
>
>
.

Relevant Pages

  • Re: Calculating Difference In Time For Age
    ... Allen Browne - Microsoft MVP. ... I guess I am just going to be out of luck with this report I ... >>>I am working on a report for a neonatal unit which requires the specific ... >>> box in my report that will return the difference (age) in days, hours, ...
    (microsoft.public.access.reports)
  • Re: Repost: Paper Size VBA Code
    ... You certainly earned the title of "MVP" ... the user has to open Page Setup and select Legal each time the report is ... > Hi Andy. ... This does not adjust the page size, but the user might be able to ...
    (microsoft.public.access.reports)
  • Re: Need report to only select the "yes" based on month
    ... is an MVP but notice it is not in Access. ... My report is based on a query and my table does have a CompanyName as well ... database to do to clarify so your table design can be further analyzed. ...
    (microsoft.public.access.gettingstarted)
  • Re: Sort Order of Report
    ... Brendan Reynolds (MVP) ... > "Brendan Reynolds" wrote in message ... In the Open event of the report set the OrderBy property. ...
    (microsoft.public.access.reports)
  • Re: print an image
    ... you can also "place" your image files into report, using image control, and then print several images ... Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com ... PrintFailure.zip is an Access97 MDB containing a report that fails during ...
    (microsoft.public.access.modulesdaovba)