I am a mid level access user and have been asked to provide reports for a
database designed by someone else in my office.I am not a programmer but
have a keen interest in access and use it regulary

I am trying to create a report based on a query, showing respondents
answers to a crime and antisocial behaviour questionnaire in a specific
area. The report must show the breakdown of numbers of respondents by
gender and how they have marked specific types of crimes by priority.

I have tried using an array to hold the different types of crimes (fields)
and have used a Do loop to loop through the records,

and dcount to count the numbers of respondents who have given the said
crimes a specific priority. Eg the crime types are as follows:  street
crimes, domestic violence, burglary etc.

There are 11 fields of these crimes and the respondent was asked to insert
their priority with 1 being the highest to 11 being teh lowest.

basically I need some help on both declaring the array, I have tried the
following and am stuck

eg dim CrimeType ()as variant

crimetype= array("[street crime]", "[domestic violence]" etc etc.
crime type = priority 1, crime type = priority 2 to be able to use these in
my DCount.

I have used dcount to count how many female respondents set street crime as
priority 1, priority 2 etc.

from my research i believe a multidemnsional arrays and loops might be the
best way to provide the results of this report. Currently my attempt was to
provide 121 expressioned text boxes using dcount.11 crime fields and 11
prioritys  
Surely there must be simpler way to achieve these results, if this is the
way to go is there also a way to output the results to a report showing the
crimes against the priority. Sorry for the long post any help will be most
greatfully received.