amend help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
My users have a table with many fields and used in a variety of querys
reports another user wants most of this data plus wants to add extra fields
..how do I set up second table so information is updated from first table
without losing new information for each record
simple example
table 1
code supplier manufacturer switch off date
yaa0000 d0001 b0001 5/5/05
yaa0000 e0001 b0001
table 2
code supplier manufacturer switch off date questionaire result
yaa0000 d0001 b0001 85
table 1 had switch off date added and new record added with new supplier
I can append new record but do not no how to amend date field in first record
Any Ideas where to start
Thanks
Tina
 
I must of been half asleep when asked this as it is pretty obvious what I
need to do that is create a query using data from both tables then create new
table and delete second table rename new table as second table
Sorry if I wasted anybody's time
Tina
 
I must of been half asleep when asked this as it is pretty obvious what I
need to do that is create a query using data from both tables then create
new
table and delete second table rename new table as second table
Sorry if I wasted anybody's time
Click to expand...

It's not a problem. We are all "half asleep" from time to time and need
someone to poke us in the ribs. <g>

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
Back
Top