[Gauze]

I don't have clients with last visits but not first visits, more like the other way around. clients that came only once. They have a first visit and so the last visit is never filled. Only the clients that had more than one visit have a last visit date. That is why I was looking for a code to automatically bring over the first date to the last visit column. The code you found works for this. I just don't think I can use it unless I were to rebuild the whole database. It seems to only work for new records. I'm not working with this database anymore at the moment so I don't need to worry about it. I'm just an extern here at this place and I thought that would be cool to get that working better. thanks very much for everything

[Advertisements]

hello Gauze,

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...

dm

[dm27]

hello Gauze,

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...

dm