Re: Calculating Difference In Time For Age

if you import the text file directly into Access, instead of first turning
it into an Excel file, you'll have much more control over how the data is
imported. you can manually import the text file first via the import wizard,
setting up each incoming field's data type, and save the import
specifications. then tinker with the import specs, if necessary, until the
data is importing correctly. at that point you can use a macro or VBA to
automate the import to run by just clicking a command button (utilizing the
saved import specification) and you'll get the desired result each time
without reinventing the wheel - as long as the format of the text file
doesn't change. post back if you need help setting up the text file import.

re using Doug's date2diff function: create a new module in the Modules tab
of your database. you can name it anything *except* the name of the
function. copy Doug's entire function code into your new module, click Debug
| Compile on the menu bar, save the module and close. post back if you get
an error when the Compile runs.

hth


"Jeff C" <JeffC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E0BEA088-56E4-4BA4-B46A-774F89417825@xxxxxxxxxxxxxxxx
> 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.
> >
> >
> >


.