link many records within 1 table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


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
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.
 
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.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top