annapolistech
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
It is IMPOSSIBLE to debug a Macro.
AW
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.
ASKER