I am very new to programming in MS Access and I am not working in this field. So please be patient with me or delete this post if inappropriate. I have a database with two tables. I need to run sequentially through the first table and for every record run a query on a second table. The records returned contains information I want to use to update two fields in the current record in the first table. The query works fine and returns the top 2 records of the second table (sorted randomly). How to do it ?
btw: I can make the db layout and query code available, but not sure how to do it within the forum rules.
Why do u want to update a feild if u are already storing the data
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
Thanks for the quick reply. Let me explain why I want to duplicate the data.
The program is for an old age home where my wife is working. They need to do "wash lists" every day. It takes them a good 30-45 minutes every day to do it. I want to help them eliminate the need to do it manually. So the first table contains the names and ward numbers of the old folks (table Residents). Second table contains the names of the care takers (table Washers).
Now what makes it difficult are the rules:
1) A washer may not work in the same ward as the day before
2) Some residents must be washed early in the morning, meaning a washer already washing someone early must be excluded from another early morning wash allocation
3) Some residents needs two washers, the others only one washer