A
Anthony Lewis via AccessMonster.com
I have Access 2002 running on Windows XP Professional. I have general
knowledge of Access, but not with VB. Most of my database experience has
been in Oracle. I have a table that I am trying to poplate on a needed
basis and have not found the proper way to do it. Here's what I am trying
to do.
I have a select the returns one to many rows of data. I want the temporary
table populated with just one row from the select. The select statement
will return something like this:
field1 field2 field3 field4
<no data> text1 <no data> <no data>
text2 <no data> <no data> <no data>
<no data> <no data> <no data> text3
I want the temporary table to show this:
field1 field2 field3 field4
text2 text1 <no data> text3
I belive I can do this with a recordset and update statement, but I am not
familar with out to accomplish this in VB. Please lend me a hand. Thank you.
Anthony
knowledge of Access, but not with VB. Most of my database experience has
been in Oracle. I have a table that I am trying to poplate on a needed
basis and have not found the proper way to do it. Here's what I am trying
to do.
I have a select the returns one to many rows of data. I want the temporary
table populated with just one row from the select. The select statement
will return something like this:
field1 field2 field3 field4
<no data> text1 <no data> <no data>
text2 <no data> <no data> <no data>
<no data> <no data> <no data> text3
I want the temporary table to show this:
field1 field2 field3 field4
text2 text1 <no data> text3
I belive I can do this with a recordset and update statement, but I am not
familar with out to accomplish this in VB. Please lend me a hand. Thank you.
Anthony