Re: Update Query Follow-up
From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 04/29/04
- Next message: B. W.: "Printing Queries Properties"
- Previous message: Saskatoon: "Using If/When type expressions in a report"
- In reply to: Luther: "Re: Update Query Follow-up"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Apr 2004 09:12:45 +1000
Post the SQL String of your current Update Query and the Date Field name of
the Field you want to update.
--
HTH
Van T. Dinh
MVP (Access)
"Luther" <lbernadel@cdc.gov> wrote in message
news:60d301c42dfd$6514e320$a301280a@phx.gbl...
> Hi,
>
> How would I incorporate this SQL in a parameter query to
> update the date field when records are changed/updated.
> The parameter query opens a form to display the records
> found.
>
> Thanks
>
> 1. I have a parameter query that opens a form
> >-----Original Message-----
> >You can use an SQL like:
> >
> >UPDATE YourTable
> >SET DateField = Now()
> >WHERE {criteria if required}
> >
> >See Access Help on UPDATE Query / SQL
> >
> >--
> >HTH
> >Van T. Dinh
> >MVP (Access)
> >
> >
> >"Luther" <lbernadel@cdc.gov> wrote in message
> >news:50e701c42c89$bae41cf0$a501280a@phx.gbl...
> >> Thank you very much for your help....Now I have another
> >> question. With the update queries that I created, is it
> >> also possible to have a Date field update itself with
> the
> >> current date when these queries are run. I can do it in
> >> forms, when you actually do something to that record,
> but
> >> I kind of want a global thing when the table is updated
> >> with all these codes.
> >> Looking forward to hear from you.
> >
> >
> >.
> >
- Next message: B. W.: "Printing Queries Properties"
- Previous message: Saskatoon: "Using If/When type expressions in a report"
- In reply to: Luther: "Re: Update Query Follow-up"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
