If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Taking data from one record, adding to previous record? Help!
Back in the ancient days of dbase, this was simple, but now I'm stumped.
I'm an amateur programmer. I'm using a table of mailing data. When there are two people at the same address, I want to put both names in a single name record (such as Bill Jones and Sally Smith, instead of two records). In dbase I would have just modified command, taken the street address, stuck it in a memory variable, skipped to the next record, compared it to THAT street address. For matches, I would then stick the name in the second record in a variable, delete that second record, skip back one record and replace name with Name plus " " plus &Memoryvariablecontents. I've done some work with queries in Access and reports, but none with modules or macros, so I will need someone to spell out the basics on this. I'm sure this is something very easy, but does anyone have the solution, or would someone please direct me to a subject that deals with it? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add data to an existing record | Raj | Running & Setting Up Queries | 3 | September 18th, 2004 02:02 AM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
auto new record on enter or data entry | Laura Q | Using Forms | 0 | July 27th, 2004 05:53 PM |
Avoid Creating A Duplicate Record | Mark | New Users | 4 | May 11th, 2004 01:52 AM |