Access 2.0

  • Thread starter Thread starter Terry Blakley
  • Start date Start date
T

Terry Blakley

UPDATE WORKWEEK_DATES SET WORKWEEK_DATES.START_DATE =
[WORKWEEK START DATE: (M/D/YYYY)], WORKWEEK_DATES.END_DATE
= [WORKWEEK END DATE: (M/D/YYYY)];

The above query works fine in ver 2000. I can't seem to
get it to work in 2.0. I need to be able to set start and
end dates for lookups.
 
Hi,


The query is equivalent to:

UPDATE tableName
SET f1= constant,
f2=otherConstant


Now, if Access 2.0 has problem, it MAY be due to the fact that Access 2.0
was not aware of any regional setting and it may be, I stress, MAY be, due
to the lack of # ( I haven't Access 2.0 installed anywhere to test its
pre-Windows 95 behavior).


Note that the query update ALL and every records of the table, if you don't
have a WHERE clause.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top