Look at Access Help for explanation and syntax of the DateDiff function.
Create an unbound control on your report and make its control source:
=DateDiff([myFirstDate],[mySecondDate])
BTW, are you really entering and storing the Name & SSN for each record?
Why not have 2 related tables (1-Many):
tblClients
clientID -autonumber, primary key
LastName - text
FirstName
SSN
etc.
tblDates
DateID -autonumber, primary key
clientID - integer, foreign key
myDate - Date/Time
Once you establish referential integrity between these tables, and setup a
Main form with client data, and a subform with date records, you'll only
need to enter a date to create a related record. Use a query of those two
tables to supply your report.
-Ed
"qtip" <cf******@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I have a simple table the has First Name , Last Name, SSN, Date&Time.
I have a report that will show all this information but I would like to
put in at calculation to tell the difference between 2 Date&time stamps
for the person. The report shows Last name, First Name and Date&Tiem
Field. If the persone has 2 records I would like to show the amount of
time between each in put.