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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.