 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / July 2006link many records within 1 table
I have a table that contains many records which need to be linked to each other. For example, one record contains a fee for charge A, the next record will contain a fee for another charge, B. These items need to be linked so that all charges appear in one record. I download the info as seperate lines so I really don't want to have to change it 1 item at a time. How on earth do I do this? I am an absolute newbie, so please feel free to explain to me as though I am just 2 years old........that way I may just understand. Thank you. You are describing a "how" ("I need to link records together"). It would help to understand the "what" (I have several different items, all related to the same person). If you are downloading the data, where is it coming from? In what format? What data structure have you set up in Access?  SignatureMore info, please ... Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ > I have a table that contains many records which need to be linked to each > other. For example, one record contains a fee for charge A, the next record [quoted text clipped - 6 lines] > just 2 years old........that way I may just understand. > Thank you. The info is downloaded from ebay and arrives as a CSV file which I then transfer in access. It arrives looking like this Date Detail Number Fee type Cost 24/03/2006 Item A 9502741660 Listing Designer Fee £0.06 24/03/2006 Item A 9502741660 Gallery Fee £0.13 24/03/2006 Item A 9502741660 Picture Fee £0.10 24/03/2006 Item A 9502741660 Item Subtitle Fee £0.30 24/03/2006 Item A 9502741660 Supersize Picture Fee £0.51 24/03/2006 Item A 9502741660 Insertion Fee £0.30 25/03/2006 Item B 9119164546 Item Subtitle Fee £0.30 25/03/2006 Item B 9119164546 Insertion Fee £0.13 25/03/2006 Item C 8271586466 Picture Fee £0.10 25/03/2006 Item C 8271586466 Item Subtitle Fee £0.30 25/03/2006 Item C 8271586466 Insertion Fee £0.13 31-Mar-2006 Item A 9502741660 Final Value Fee £2.77 As you can see, each number has more than 1 cost associated to it. I just need to put them into 1 record which will show a total cost per item number. Hope this helps in your quest to help me. Kate. > You are describing a "how" ("I need to link records together"). > [quoted text clipped - 16 lines] > > just 2 years old........that way I may just understand. > > Thank you. Kate Although you may wish to "put them all in one record", that isn't how Access works. Or rather, if you want to use what Access can do for you, you DON'T want to use "repeating fields" (feetype1, amt1, feetype2, amt2, ...). This is what you'd do if you were using a spreadsheet. To use the data as you now receive it, you could store it in an Access table with the structure it comes with. You'd then create a new query against that table. If you want the sum of all fees, you'd use a Totals query, grouping by the Number. If you want to see all the FeeTypes and amounts, for each Number, you'd use a Crosstab query. By the way, you might want to change the field names in your Access table. "Date" and "Number" are Access reserved words ... using them as field titles will only confuse both you and Access. SignatureRegards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ > The info is downloaded from ebay and arrives as a CSV file which I then > transfer in access. It arrives looking like this > Date Detail Number Fee > type Cost 24/03/2006 Item A 9502741660 Listing Designer > Fee £0.06 > 24/03/2006 Item A 9502741660 Gallery Fee £0.13 [quoted text clipped - 34 lines] > > > just 2 years old........that way I may just understand. > > > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.