Link to home
Start Free TrialLog in
Avatar of annapolistech
annapolistechFlag for United States of America

asked on

How do I add data to a row in MS Access without using update

I have a temp table (in MS Access) with 7 columns. ID, projName, projInfo, enggFname, enggLname,devFname, devLname.
Using an " insert into select" statement, I insert a row with ID, projName and projInfo from tblProjects into tblTemp.
 tblProjects also contains enggID and devID as foreign keys. Using these foreign keys and other filter criteria, I need to add the enggFName, enggLname to the already existing row in tblTemp. Then I have to repeat the process to add devFname and devLname to the row in tblTemp to complete the insert.
Can I do this in a single query? I have tried using union and append without success. I need to have only a single row with the data inserted in parts in the temp table.
Any suggestions as to how I can build the query, or write multiple queries but execute them after a single event?

Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of Arthur_Wood
Arthur_Wood
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of annapolistech

ASKER

Thanks for the replies, I will try the solutions and let you know.
You should be aware that Macros in Access are not a good idea.  Microsoft strongly advises against using them (they are only supported in 2000+ for compatability with earlier versions of Access).  

It is IMPOSSIBLE to debug a Macro.

AW
Avatar of mfsamuel
mfsamuel

Not that you are wrong, but can you provide a reference to support that statement?  I have used macros for years, and have found that automating many things is only posible with VBA code.