Date from through a Date to field in one feeld

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with a Juvenile Detention Office and need help if possible
I have one field that has the date entered in Detention. (1
I have the next field that has the number of dates incarserated. (2
I have the next field that has the Date to be released (this date is from 1+2
I need a field that allows the date from through the date released (example: 01/25/04 - 02/03/04
If I can use the information from 1, 2, 3 that is ok.
Anyone have an expression or a way around the date function

Regina
 
I assume you intended (2) to be "days" inarcerated.
I'll call the date entered [Entered]
The number of Days [Days]
To obtain the release date would be "=[Entered]+[Days]"
without the quotes
Hope this helps.
Let me know if I misunderstood your intention.
Fons
-----Original Message-----
I am working with a Juvenile Detention Office and need help if possible.
I have one field that has the date entered in Detention. (1)
I have the next field that has the number of dates incarserated. (2)
I have the next field that has the Date to be released (this date is from 1+2)
I need a field that allows the date from through the date
Click to expand...
released (example: 01/25/04 - 02/03/04)
 
Regina,

You can do this in a calculated field in the query that your report is
based on, like this...
IncarcerationPeriod: Format([EntryDate],"dd/mm//yy") & " - " &
Format([EntryDate]+[DaysIncarcerated],"dd/mm//yy")

Or you can enter it in the Control Source property of an unbound textbox
on the report, like this...
=Format([EntryDate],"dd/mm//yy") & " - " &
Format([EntryDate]+[DaysIncarcerated],"dd/mm//yy")

Obviously, you will need to substitute your own actual field names for
EntryDate and DaysIncarcerated... you didn't mention your field names so
I had to guess.
 
Back
Top