Update Query Help

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

I am trying to do an update query on 07-09 A2 from 07-09 A. Both are date
fields on tables. The only problem is there may be 2 or 3 records that have
been changed this year and it wants to update all 90 records. I tried in the
criteria Between 1/1/2008 and 5/13/2008 but it still trys to update all 90
records. I mean, it won't hurt anything to re-install the previously existing
records along with the new ones, but what if it would. I'm doing something
wrong somewhere. Help! Thanks so much!!!
 
I am trying to do an update query on 07-09 A2 from 07-09 A. Both are date
fields on tables.
But '07-09 A2' is not a date.
 
Sorry I wasn't very clear, 07-09 and 07-09 A2 are tables with date fields.
The actual name of the field in both is Date Agreement Received. Thanks!
 
Obviously it would help to see the SQL of the query you are using.

I would think that if you only want to update the changes you would have
something in a where clause that read

WHERE [07 09].[Date Agreement Received] <> [07 09 A].[Date Agreement Received]

Of course, you would have to handle null values if either of the Date
Agreement Received fields could be null.



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Back
Top