date range

[DAwn]

Is it possible to set up a field that contains a date
range? I do not want two separate fields for start date
and end date. I know I can set it up as text and type
dd/mm/yy - dd/mm/yy. However I need it to be recognized
as a date format.

 

[Cheryl Fischer]

Dawn,

If the field must be of DateType, then you need two fields: StartDate and
EndDate. Setting up a text field with embedded start and end dates will
doom you to extra work every time you write a query or an expression based
on a period of time. There are a wealth of functions available in Access
VBA for selecting on, converting/extracting parts of dates, and doing
arithmetic with dates that require a Date type, so I recommend you stick
with the StartDate and EndDate concept.

hth,