Database Help Please

[bacarat]

Hello,
This is my first post here but I have been reading this forum for a while now. Just wanted to say I appreciate all of the shared knowledge everyone has given in this forum.

I am new to access and only know the basics of data entry and a small amount of VB.
I post today to ask for some help, I am working on a database and I need to setup a series of categories and then select an option for that category and graph the % each one has occurred. For example:

Category 1:
-Option A -Option B -Option C

Category 2:
-Option A -Option B -Option C

Here are some examples of the graphing I need to do:
Graph 1: What % in category 1
Graph 2: What % in category 1 are option A.

And so on from there. I am having trouble writing a from the get this dat organized into a table as well. I have tried for a few days and am looking for some tips or suggestions on a simple way I can get this data organized and into a bar graph.

I have tried checkboxes with a different numerical value for each category and option option and have tried graphing it based on the numbers I get but I am not sure how to do this correctly. I have also tried putting in a drop down with the different options but I opfen come up confused with this data in text form and do not know how to tell excel to count the number of times a certain word has occurred in a table.

Any help or suggestions would be greatly appreciated. Thank You in advance.

 

[Scottyk537]

Not enough info..........
Based on what you said, I would setup the table and a bunch of yes/no(boolean) values.
Then whan you run a query, count how many [Option A]'s = -1

 

[bacarat]

Would i use a Dcount formula for this? Sorry havent done much coding in access.

 

[Scottyk537]

Open the query, right click on a field below and select 'totals'. A new row appears called 'totals'. In the [option A] column, totals should be 'count' and criteria should be 'like -1'

 

[bacarat]

Thank you! I got it woking, is it possible to set a count to multiple criteria, for example count if one column equals 2 and another equals -1?

 

[Scottyk537]

Yes,
If your in the same query, it's only going to count rows where columnA equals 2 AND columnB equals -1.
If you need to count multiple fields separatly, create different queries. Then you can create a 'master' query that looks at your other queries.

 

[boblarson]

If you want the count of the columnA you can put

ColumnACount:Count(IIf([columnA]=2,1,0))

for ColumnB:

ColumnBCount:Count(IIf([columnB]=-1,1,0))

for needing ColumnA to be 2 and ColumnB to be True

ColumnCount:Count(IIf([ColumnA]=2 AND [ColumnB]=-1,1,0))