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 SkipVought 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. tiffjones001

    Creating database for Data Entry, Reports - how to set up the tables?

    Here are the fields that I want to use (I may trim down). There are a few that I want to pull up a calendar to input the date (right now I have the date entry format set and it works fine) The check boxes I wanted for choices such as the "cost savings" ... whether Recurring or Non-recurring...
  2. tiffjones001

    Creating database for Data Entry, Reports - how to set up the tables?

    Hi, I'm about to create a new database to perform simple project tracking and I would like your help on the design and "normalization" (?) of setting up the tables to create and use a Form for data entry and to create Reports. I have a main table containing most of the fields I need, but I'm...
  3. tiffjones001

    Populate fields based on value in another table - how to?

    So I bravely ran the query.. it worked beautifully! I think it is true that there were 531 records in the with table where those 61 without records showed up. Now why it said that 531 would be updated.. is still a mystery to me. But the bottom line is.. it worked. Thank you PWise and dhookom...
  4. tiffjones001

    Populate fields based on value in another table - how to?

    Ok I tried it, but just short of actually running the update query because the # of records it would update is far greater than the # of records on "without" table. Here's what I have: With Table = 61 rows (the query was going to update 531 rows) UPDATE [Without table] INNER JOIN [With...
  5. tiffjones001

    Populate fields based on value in another table - how to?

    Hi, Here is the situation: I have 2 tables, one has part number descriptions and the other does not. Both tables have identical part numbers, so this is the link between the two. How do I populate the one table's missing part number descriptions with the other table's part number descriptions...

Part and Inventory Search

Back
Top