Re: Using Date as one of the field in Access
- From: "Debra Farnham" <dfarnham@xxxxxxxxxxxxxx>
- Date: Mon, 25 Apr 2005 11:48:29 -0400
Hi Jack
Date is a reserved Word in Access (it is actually a function). Try using a
tag in front of the word date or add a more descriptive word before the word
date and your query should work (so long as the syntax is correct which I
did not check).
HTH
Debra
"Jack" <Jack@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:14F64492-9049-451E-B545-0B651B8283F0@xxxxxxxxxxxxxxxx
> Thanks for your advise. I changed my update code as:
> UPDATE tblExpense SET Date = #03/15/2005# , contractedServiceExpense='15',
> travelexpense='20', pesonnelexpense='5' WHERE tranid='2'
> With this change though the same error is there with the date field being
> highlighted. Any thoughts? Regards.
>
> "OsmarJr" wrote:
>
> > Try:
> >
> > UPDATE tblExpense SET Date = #03/15/2005#,
> > contractedServiceExpense='15', travelexpense='20', pesonnelexpense='5'
WHERE
> > tranid='2')
> >
> > Dates and times must be enclosed in ##.
> >
> >
> > "Jack" escreveu:
> >
> > > Hi,
> > > I am using Date as one of the fields in a Access table. Now when I am
tring
> > > to run a update query (UPDATE tblExpense SET Date ='03/15/2005',
> > > contractedServiceExpense='15', travelexpense='20', pesonnelexpense='5'
WHERE
> > > tranid='2') , I am getting an error with a highlight on Date. I do no
know
> > > why this is happening. I would appreciate any help on this. Thanks.
Regards.
.
- References:
- Using Date as one of the field in Access
- From: Jack
- RE: Using Date as one of the field in Access
- From: OsmarJr
- RE: Using Date as one of the field in Access
- From: Jack
- Using Date as one of the field in Access
- Prev by Date: RE: Using Date as one of the field in Access
- Next by Date: Re: Best practice for table design
- Previous by thread: RE: Using Date as one of the field in Access
- Next by thread: Re: Using Date as one of the field in Access
- Index(es):
Relevant Pages
|
