Duplicated data in a report

Hi folks,

I have re-read my earlier post asking for assistance with a report.
It made no sense to me, so I'm not surprised that no-one replied.

I'll have another go:


We maintain a database where local firms offer work experience to
pupils at our school. Once per year students choose three firms that
they are interested in working for.
I need to see a report that shows for every firm, which pupils have
selected it as a first choice, which have it as a second choice and
which as a third.


Here are the structures of my tables:


Employers Jobs
offered Pupils
==================================================================================
RefID------linked-------------------Ref
ID PupilID
Name JobID-----------
linked----------------First choice

----------------Second choice

----------------Third choice


Pupils choose a job by writing the JobID in their first, second or
third choice.
Some employers offer more than one job.



Via a query I can produce a report that shows for each job, who has
selected it as a first choice.

Whenever I try to produce a report that shows for each job, who has it
as a first choice and who as a second, I get lots of data repeated.
I've tried editing the textbox's properties in the report to remove
duplicates, but they still appear.



As said, I'm a beginner, I can produce this in Excel quiet easily, but
it runs slowly.
Someone suggested using access could speed it up?
Am I asking Access to do something impossible?

Please help, I've reached, and passed the shouting at the monitor
stage!

Cheers

Tony
.

Relevant Pages

  • Re: Spam via feedback form
    ... abuse, which is generally frowned upon by people who are putting ... Don't have it report each instance individually, though, because ... > as a first choice for RISC OS-related sites? ...
    (comp.sys.acorn.networking)
  • Re: Maths exams dumbed down to give New Liebour great pass results PR
    ... to teach pupils the skills needed to gain good jobs, ... Schools should build on the interest in maths puzzles such as Sudoku to ... transformations and using and applying mathematics," said the report. ...
    (uk.politics.misc)
  • Half school failures are white working-class boys, says report
    ... Ethnic minority pupils less likely to be bottom of class ... White Britons of both sexes who begin failing at primary school are more likely ... The report, for the Joseph Rowntree Foundation, challenges common perceptions ... Extra funding to combat disadvantage is also advised. ...
    (soc.men)
  • Chaging data used
    ... I have a report that genterates Meal Uptake for each school. ... The Uptake of meals is based round the no. pupils in the school, ...
    (microsoft.public.access.reports)
Loading