Update Query Help

[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!!!

 

[KARL DEWEY]

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.

 

[Golfinray]

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!

 

[John Spencer]

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