[AccessD] SQL to Change a field value based on an input

connie.kamrowski at agric.nsw.gov.au connie.kamrowski at agric.nsw.gov.au
Wed Apr 13 23:43:03 CDT 2005


Hi All,

I am trying to write a quick update which will change athe status field in
my DB to 1, and the status date to today if a date criteris is met. here is
my SQL

UPDATE tblDAuthorityRenewal SET tblDAuthorityRenewal.Status = 1,
tblDAuthorityRenewal.StatusDate = Date()
WHERE (((tblDAuthorityRenewal.EndDate)=#11/1/2003#));

except I am passing a parameter into the last bit (of course)

If I run this SQL either directkly or in my form the date changes to today
but the status doesn't change ...

Yours in confusion
Connie Kamrowski

Analyst/Programmer
Information Technology
NSW Department of Primary Industries
Orange




This message is intended for the addressee named and may contain
confidential information. If you are not the intended recipient or received
it in error, please delete the message and notify sender. Views expressed
are those of the individual sender and are not necessarily the views of
their organisation.





More information about the AccessD mailing list