Posted 09 March 2010 - 09:39 AM
Posted 09 March 2010 - 11:34 AM
That's ok and if you want to update the table for any records that has a first visit but no last visit you can use the below SQL code in an Update query. I don't have Access 2007 here, but I believe you can find the Update Query option in the Query tab- then use the SQL view to enter the code below.
As usual, test on a copy of your table
Change the column name and table name to match your info.
UPDATE your table name SET table name.Lastvisit = table name.firstvisit WHERE table name.Lastvisit is null
Best of luck with your externship...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users