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

Steve Erbach erbachs at gmail.com
Thu Apr 14 16:48:45 CDT 2005


Connie,

I don't suppose it's something mundane like the Status field being a
Text field instead of Numeric, is it?

Steve Erbach

On 4/13/05, connie.kamrowski at agric.nsw.gov.au
<connie.kamrowski at agric.nsw.gov.au> wrote:
> 
> 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



More information about the AccessD mailing list