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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Matching information in 2 tables
Situation: I currently have 2 tables with the following information- 1) Table_Software (6300 records): Company_Name, Address, City, State, Zip columns 2) Table_Network (13000 records): Company_Name, Address, City, State, Zip, Duns#, SIC, Revenue columns Issue: Company_Name information has...- chica3578
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Automatically fill in current date in a Table
Hello, I have a table with multiple columns and the information needs to be verified manually line by line. I've added 2 columns "Verification" (Yes/No Data Type) and "Verification Date" (Date data type). Is it possible that when I check "Yes" in the...- chica3578
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
-
Counting & deleting duplicate records from a table
Hello, I have a table with multiple columns. The problem is that my DUNS# column has duplicate records with the same number. How can I build a query that counts the # of times each duplicate record shows up. If I wanted to delete the duplicates and keep only one, how would I do so and keep...- chica3578
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
Multiple Record Sources in Access reports possible???
I am trying to create a report in Access that uses multiple queries to show data. I have tried consolidating all the multiple queries into one, but my data gets messed up. Is there a way to use multiple record sources on a report without creating a subreport? Thanks!- chica3578
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
