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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access Deleted a Table while Synchronizing Databases
Hello all. I have 8 copies of a database that others are collcting data in while I work on the Master file. I made changes yesterday morning and made copies for everyone. Since then I had imported and exported the data from previous versions of the database into a table that was named the same...- JDows
- Thread
- Replies: 1
- Forum: Microsoft: Access Tables and Relationships
-
Finding the Non distinct records
I am trying to find those records that have duplicate primary key #s so I can delete them. I can create a query for those that are distinct, select distinct from table1 but how do I get the others that are not distinct?- JDows
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Joining two tables with similar information into one table.
Ok, here is my problem. I have two tables that hold the exact same information for different departments. (All of the fields are the same, but each record is unique between both tables. There are no crossovers so I don't think right/left join will work) What I would like to do is just stack...- JDows
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Inserting at End of Excel data
I have a monthly data update that I would like to put in an Excel macro. I need to take a set of rows (a specific amount) from one sheet and put them at the bottom of another worksheet (varible set of rows- added onto every month). I have figured out how to insert at the top of this data...
