By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,679 Members | 1,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,679 IT Pros & Developers. It's quick & easy.

Help with counting occurances of similar text

P: n/a
Hi all,

I have a fairly simple database containing details of broadcast news
reports. Each record contains information about the programme title, date,
time, presenter, and details of the interviewees (if any) who contributed to
a particular report.

What I need to be able to do is count up instances of repeated text within
the database. For example, I would like to be able to run a query which
would provide a list of all the various programme presenters, and how many
reports they each presented.

e.g.

John Humphrys 54
Sarah Montague 56
Mark Coles 22
I also need to set up a more complex query, relating to interviewees and
guests. Contributors to each separate news report are set out in this
format:

Contributor1_N: Name of Interviewee
Contributor1_P: Political Party
Contributor1_IS: Interview or Soundbite

Contributor2_N: Name of Interviewee
Contributor2_P: Political Party
Contributor2_IS: Interview or Soundbite
(There is space for up to eight separate contributors, all set out in the
same way).

How would I, for example, write a query which gives a total for contributors
from, say, the Labour Party? Presumably I would have to somehow add up
occurrences of the phrase 'Labour Party' from Contributor1_P to
Contributor8_P .

I think what might suit me best would be a query which would list every
possible input in all of the eight Contributor_P categories , and give a
total next to it.

e.g.

Labour Party 65
Conservative Party 54
Liberal Democrats 26
Green Party 1
Scottish National Party 1

I realise I've probably constructed the database poorly in the first place,
but would very much appreciate it if anyone could offer me some help,
explained in very simple terms if possible.

Many thanks

Andrew, (Brighton, UK)
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Have a look at the 'like' operator in Access Help. Used in
a query that should get a result set which you can then use
the Count() function on.

Do it in stages, design the query to get the results you
want then muck about with count() to get the numbers you
want. Count() is in the help as well.

Good luck

--
Nick Coe (UK)
Available - Will work for money :-)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store

In news:n_********************@giganews.com,
remove ntlworld.com typed:
Hi all,

I have a fairly simple database containing details of
broadcast news reports. Each record contains information
about the programme title, date, time, presenter, and
details
of the interviewees (if any) who contributed to a
particular
report.

What I need to be able to do is count up instances of
repeated
text within the database. For example, I would like to be
able to run a query which would provide a list of all the
various programme presenters, and how many reports they
each
presented.

e.g.

John Humphrys 54
Sarah Montague 56
Mark Coles 22
I also need to set up a more complex query, relating to
interviewees and guests. Contributors to each separate
news
report are set out in this format:

Contributor1_N: Name of Interviewee
Contributor1_P: Political Party
Contributor1_IS: Interview or Soundbite

Contributor2_N: Name of Interviewee
Contributor2_P: Political Party
Contributor2_IS: Interview or Soundbite
(There is space for up to eight separate contributors, all
set
out in the same way).

How would I, for example, write a query which gives a
total
for contributors from, say, the Labour Party? Presumably
I
would have to somehow add up occurrences of the phrase
'Labour
Party' from Contributor1_P to Contributor8_P ..

I think what might suit me best would be a query which
would
list every possible input in all of the eight
Contributor_P
categories , and give a total next to it.

e.g.

Labour Party 65
Conservative Party 54
Liberal Democrats 26
Green Party 1
Scottish National Party 1

I realise I've probably constructed the database poorly in
the
first place, but would very much appreciate it if anyone
could
offer me some help, explained in very simple terms if
possible.

Many thanks

Andrew, (Brighton, UK)

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.