Help!

subfields

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Table Design RSS
Next:  Mail Merge: Customize Greeting Line  
Author Message
Clarendon
External


Since: Sep 10, 2009
Posts: 2



PostPosted: Thu Sep 10, 2009 8:26 am    Post subject: subfields
Archived from groups: microsoft>public>access>tablesdbdesign (more info?)

My question keeps disappearing. Does anyone know why? I've entered this
question almost ten times and yet when I come back it is gone. I will keep
entering it in different boards until I see it stay there.

I am working with data that seem to require subfields. I am using Access 07.
I am analyzing features of instances of phrases I search in the Internet:

Phrase Category 1 Cat 2 Cat 3
A 5 / 50% 5 / 50% 0
X2, Y3 Z5
B

The table shows that phrase A has 10 instances, 5 in Cat 1 and 5 in Cat 2.
These instances have features marked with XYZ. Table shows that for A the
five instances of Cat 1 are broken down to 2 of X and 3 of Y, and so forth. I
would like to sort this data like: 'for A list the features that are in the
Categories that score freqencies below 10%' and 'list the Categories with
only one feature (Cat 2 in the table)'.

Can access handle this data? I think multi tables is not helpful because
they only add further info for values, not fields. I need to add further info
for fields (Cat) by setting up subfields of frequency and feature. Also, I
don't think multivalue option will help because it works only as a lookup
(can't add random numbers).

I tried using two primary keys (Phrase and Type) to correspond to each
subfield as follows:

Phrase Type Cat 1 Cat 2 Cat 3
A Freq. 5 5
A Perc. 50 50
A Feature X2, Y3 Z5
B
B
B

This may be a solution, but is quite cumbersom. Also, I am not sure if I
will be able to do the queries I mentioned above. Thank you very much for
your help.
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Table Design All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum