Re: how do i put text values in date/time field in microsoft acces

Don't worry about it, tina. Rick B sort of considers himself the newsgroup
police.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html


"tina" <tina@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:45F7C84C-2F6A-488C-9DDD-309CA48A8839@xxxxxxxxxxxxxxxx
> Sorry for the confusion of posting it more than once. It did not give me
> a
> confimation the first time i posted it, so i had post it again. So, I
> guess
> both went though. Thanks for your help and time.
>
> "Rick B" wrote:
>
>> Answered in your OTHER post. Please do not post multiple times. You
>> don't
>> need several different people answering your question only to find it
>> already answered in another group. That is very annoying for the person
>> who
>> spends their time and effort trying to help you out.
>>
>> --
>> Rick B
>>
>>
>>
>> "tina" <tina@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:BD587776-2B1F-4E41-A282-245D9B763D06@xxxxxxxxxxxxxxxx
>> > I am having trouble setting a date/time data type field to accept text
>> values.
>> >
>> > For example,
>> > Currently the date/time can only put dates (5-29-2005)
>> >
>> > But, I want to put text in there too
>> >
>> > For example: if the date is not available I would like put "N/A" to
>> indicate
>> > that date is not available.
>>
>>
>>


.

Relevant Pages

  • Re: [OT] Re: Primary Key Autonumbers
    ... Lynn Trapp ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Access Junkie List: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Not Operator
    ... Lynn Trapp ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Access Junkie List: ...
    (microsoft.public.access.queries)
  • Re: Password expiring
    ... Lynn Trapp ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Networkdays Function in Access 97
    ... Lynn Trapp ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html ...
    (microsoft.public.access.queries)
  • Re: number sequence
    ... Lynn Trapp ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Access Junkie List: ...
    (microsoft.public.access.tablesdbdesign)
Loading