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 derfloh 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: *

  1. chica3578

    Matching information in 2 tables

    I used the unmatched query wizard already. The probles is want to be able to match records based on multiple criteria and not just one as the query does.
  2. chica3578

    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...
  3. chica3578

    Automatically fill in current date in a Table

    Bob, I don't have form bound to the table. I am directly going into the table to make my changes and updates. Therefore, when I check 'Yes' in the Verification column, I need the "VerificationDate" column to automatically fill with today's date. Thanks!!! -r-
  4. chica3578

    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...
  5. chica3578

    Counting & deleting duplicate records from a table

    Thank you so very much. I will try those queries tomorrow. I appreciate your help.
  6. chica3578

    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...
  7. chica3578

    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!

Part and Inventory Search

Back
Top