Update feild with current date from query

[Kat]

I have a query that gives me all orders that are over 30 days old. I want to
run a second update query off that to enter a date in the email notice date
field when I ran the report. How do i do that?
Field = ReleaseDate
Table = RepHldList
Update to - RepHldList!ReleaseDate=Date()

It is not updateing the date to the field in the table.

 

[MGFoster]

I have a query that gives me all orders that are over 30 days old. I want to
run a second update query off that to enter a date in the email notice date
field when I ran the report. How do i do that?
Field = ReleaseDate
Table = RepHldList
Update to - RepHldList!ReleaseDate=Date()

It is not updateing the date to the field in the table.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not sure this is what you want so be sure to back up your table before
trying this:

UPDATE RepHldList SET ReleaseDate = Date()

I'm guessing you'll need some criteria to ensure you update the correct
rows (records). Something like:

WHERE unique_identifier IN (SELECT unique_identifier
FROM report_query)

The unique_identifier would be the identifying column in the report
query that uniquely identifies the separate orders.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSXjn94echKqOuFEgEQJVjgCg9Ubm37c8ANL1sFvy5FqmKJKwe9EAoNxY
F+kAgH5Of5Xl9bpMxtWvnrDU
=Q8O1
-----END PGP SIGNATURE-----