Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: larkeyshark
- Order by date
-
help with delete and update queries
I am trying to update addresses in another database when records in my database are changed. I do not need to check which actual field is changed, so I simply delete (via query) the corresponding addresses in the other database and replace with the current ones from my database (both databases...- larkeyshark
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
select and insert statement
HI Wayne I appreciate your help but your code seem to do more than I need, my fault for not being clear enough. Here is what I am trying to do: I have a master table (say tblMaster) containing a large number of records, mainly name and city. I need to insert records from the master table to...- larkeyshark
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
select and insert statement
HI Wayne I could not make a query with TOP work. More detail: There are 5 tables that need to be populated from the master table. Each table will receive 100 records from each city, not the same records of course; so if I use TOP I need a way to identify or delete from the master table the...- larkeyshark
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
select and insert statement
Help!!!I am working with a master table containing a large number of records (names and cities of residence sorted by city). I need to insert 500 records from the master table to 5 secondary tables. Each secondary tables will receive 100 records from each of the 5 cities. I tried with a do...- larkeyshark
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
