PC Review


Reply
Thread Tools Rate Thread

Complex table linking

 
 
Patch
Guest
Posts: n/a
 
      7th Dec 2007
Hi there,

Need some help with the following two problems.

1. Create two sets of tables that must each run numerically. For example set
one muct have a field that counts A1, A2, A3 etc. For set two also a unique
count field, B1, B2, B3 etc. Each of these tables will also have a unique
name / title.

2. I then need a 'contents' table that will take A1, A2, B1, B2 etc and link
ther respective titles.

I hope this is enough information to help.

Thanks,
Patch

 
Reply With Quote
 
 
 
 
Pierre
Guest
Posts: n/a
 
      7th Dec 2007
Are you trying to do this in Word or Excel. I ask b/c your post is in Word
Gerneral Questions. None the less, its seems as if you have a small formula
issue. If you want to add cell values, use the SUM option. If you want to
combined cell values, try useing CONCATENATE.

NOTE: SUM example A4=SUM(A1:A3) or A4=SUM(A1,A2,A3,B1,B2,B3)
CONCATENATE example CONCATENATE(A1,A3)
--
Work is sometimes hard....but someone has to do it.


"Patch" wrote:

> Hi there,
>
> Need some help with the following two problems.
>
> 1. Create two sets of tables that must each run numerically. For example set
> one muct have a field that counts A1, A2, A3 etc. For set two also a unique
> count field, B1, B2, B3 etc. Each of these tables will also have a unique
> name / title.
>
> 2. I then need a 'contents' table that will take A1, A2, B1, B2 etc and link
> ther respective titles.
>
> I hope this is enough information to help.
>
> Thanks,
> Patch
>

 
Reply With Quote
 
Patch
Guest
Posts: n/a
 
      7th Dec 2007
Thanks Pierre,
This is a Word question hence a little more tricky I suppose? Any
suggestions for Word?

"Pierre" wrote:

> Are you trying to do this in Word or Excel. I ask b/c your post is in Word
> Gerneral Questions. None the less, its seems as if you have a small formula
> issue. If you want to add cell values, use the SUM option. If you want to
> combined cell values, try useing CONCATENATE.
>
> NOTE: SUM example A4=SUM(A1:A3) or A4=SUM(A1,A2,A3,B1,B2,B3)
> CONCATENATE example CONCATENATE(A1,A3)
> --
> Work is sometimes hard....but someone has to do it.
>
>
> "Patch" wrote:
>
> > Hi there,
> >
> > Need some help with the following two problems.
> >
> > 1. Create two sets of tables that must each run numerically. For example set
> > one muct have a field that counts A1, A2, A3 etc. For set two also a unique
> > count field, B1, B2, B3 etc. Each of these tables will also have a unique
> > name / title.
> >
> > 2. I then need a 'contents' table that will take A1, A2, B1, B2 etc and link
> > ther respective titles.
> >
> > I hope this is enough information to help.
> >
> > Thanks,
> > Patch
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complex 2 table formula JD Microsoft Excel Worksheet Functions 4 30th Dec 2009 12:35 AM
complex linking data and files Ruth Microsoft Excel Misc 3 5th May 2009 09:56 PM
Linking to other spreadsheets - complex formula =?Utf-8?B?Q2FsaWZvcm5pYSBQaGls?= Microsoft Excel Programming 2 2nd Sep 2006 07:02 AM
Complex Table Design =?Utf-8?B?U3JNb3Vzc2U=?= Microsoft Access Database Table Design 2 28th Jun 2005 05:38 PM
what seems a complex problem looking up a value in a table Andre C Microsoft Excel New Users 1 20th Apr 2004 12:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:18 PM.