MS Access Issue?

Question

Hello All... I have created a table in MS Access 03 for my boss of Key Terms that children said after a pilot class of Genetics we gave in PA. I showed her what I had and she loved it. But she wanted to know if there was a way to tally how many times this term was used throughout the 4 day period.
Is there a way to do this? Because I have wrecked my brain and I can't come up with anything.

Thank You. All of your help is much appreciated.

Answer 1

How do you want to count the terms used? Enter it in the table every time it is used or increment a counter each time?

If you enter it each time, then yes a query that summarizes the occurances will work. You may be pretty busy entering the term.

I suggest you create the query with the same field in two positions. In your Query, you do View Totals and in the Totals row, make one of your fields, "Group By" and the other you make it "Count" That shows you the term and the count of the term.

If you want to click a button next to an existing term that will increment a counter, you need to use a form.

Create a table with fields for Term and Count, Text and Number.
Create a form using the wizard on that table, my example is Table1. Select both Fields, Columnar type and save, then edit.
In form properties, change Default View to Continuous Forms.

Then add a command button. When the wizard comes up, click cancel. Rename the button. Mine is "Count incr/decr" because I'm toing to give it both functions.

Right click on the button and choose properties. Goto the event tab and find On Click. Choose Event procedure and click the elipse to the right [...]. Type in fcount = fcount + 1. Close the window. In On Key Press, do the same but make it fcount = fcount -1. Clicking will increment and pressing any key will decrement the counter. Go to your count field and in properties change the "Name" (not "Control Source") to the name fCount. This is because the word Count is reserved and can't be used in the code.

Now run your form. Enter terms and click on the button to count how many times they are used. And if you accidentally click on the wrong term, press a key and it will decrement.

You can also enter a number in the count field replacing what is there, if you want to add 10, but not click 10 times.

There is a very sophisticated way to count the terms, but it isn't too hard to do really. It just means digging deeper and making 'changes under the hood', so to speak.

Note: in testing I find that when you enter a number in the count field, it registers as a keypress when the tab goes to the button. you can compensate for that by clicking the button once to adjust or, make the button 'not a tab stop' That is in properties, under the 'other' tab.

Answer 2

The first answer is good, they gave you a fish. Now I will teach you how to fish so you are fed for a lifetime.

In the query section select New Query, Use the wizards to create a cross-tab query. Presto!

You will see some other nice wizards there that I am sure will come in handy some day.

Answer 3

Yes, there are many ways. One would be to collect all key terms as they are said (it doesn't matter if they are repeated, you can group them later). Separate each day into columns. Then sort them and group them so you can count how many times was each key term mentioned each day. You can also graph them to see on what days an individual term was mentioned the most. Hope this helps.

Answer 4

Yes there is.

What you need to do is create a query. Then group the fields and use the COUNT feature to count how many times the word occured.

Example:
SELECT Count(Table1.[Key Terms]) AS [CountOfKey Terms], Table1.Day
FROM Table1
GROUP BY Table1.Day;

Answer 5

In VB code you should use the inputbox() function to instantaneous for and seize the appliance#. Then use that cost of that variable interior the DoCmd approach DoCmd.FindRecord ... (could get syntax ultimate) although i contemplate whether you may no longer be thinking approximately your database layout. the whole element of a relational database is which you have "computerized links" between appropriate documents tables. wish this enables slightly.

Answer 6

Using algebra I come up with 23,000.000.000.000