New to Access

[gz3s36]

I have never used Access before. I use Excel. Anyways, I need to do one thing in Access. I have a column called 'last purchase date' in theemployeepurchase:table. I need to populate that column from the tblwrite:table. with each employees last purchase date. I know I am in over my head but maybe someone can point me in the right direction.

[ranman256]

make a query, Q1, to get the employee last purchase date.
(turn on summation)

Q1 = select Emp#, Max(purchaseDate)

now you cannot update AND sum in queries, SO , you must write this data to a temp table. So have the query , make table to tTemp table.
then make Q2, use tTemp and update to your other table: tblwrite:table
join tTemp to tblwrite on Emp# then update the LastPurchseDate field.

[gz3s36]

Thank you, I'll give it a try.