[AccessD] Re: SQL to Change a field value based on an input _ Solved

Ahhh Stuart it was our old friend the date format issue. I have re written
to change date to the correct format and enclose in ## (thanks to some code
Gustav supplied when I first came here and now it works fine ... I should
have thought of Date issues first I guess

Connie Kamrowski

Analyst/Programmer
Information Technology
NSW Department of Primary Industries
Orange


Message: 19
Date: Thu, 14 Apr 2005 16:48:45 -0500
From: Steve Erbach <erbachs at gmail.com>
Subject: Re: [AccessD] SQL to Change a field value based on an input
To: Access Developers discussion and problem solving
             <accessd at databaseadvisors.com>
Message-ID: <39cb22f30504141448124186bf at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

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


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.