John,

Thanks your quick response. I did wonder if I was correctly explaining
myself, which is in part not helped by me not fully understanding the subject.

The first thing I need to establish is I've inherited this database when I
joined this company, and had in order to meet all the different requirements
over the years has been added to and tinkered with so that it's a massive
unwieldy beast.

So, for reporting on events you enter details into a form and then click on
one of 6 command buttons to open the corresponding report, of which there are
6. My problem is that firstly it looks horrid and is a pain to navigate, but
more importantly if you change the format or add a field you then have to go
through and alter 6 reports!

In my effort to stream line things and make it easier for future
developments is to have one report that can cope with 6 different arguments,
which are:

1) I want to see all records between two dates - e.g all events between
07/04/08 and 30/04/08
WHERE (((tbl_event.eventstart)<=[forms].[reportmenu].[startdate]) AND
((tbl_event.eventend)>=[forms].[reportmenu].[enddate]))

2) I want to see all records for a specfic sport type - e.g. all rugby union
events
OR (((tbl_event.sporttype)=[forms].[reportmenu].[type1]))

3) I want to see all records for a specific year - e.g. all events in 2009
(I've been using the datepart function as no-one included a year column in
the events table)
OR (((DatePart("yyyy",[eventstart],7,2))=[forms].[reportmenu].[year1]))

4) I want to see all records for a specific sport type in a specific year
(e.g. all rugby union events in 2009)
OR (((tbl_event.sporttype)=[forms].[reportmenu].[type1]) AND
((DatePart("yyyy",[eventstart],7,2))=[forms].[reportmenu].[year1]))

5) I want to see all records for a specific sport type between two dates -
e.g. all rugby union events between 07/04/08 and 30/04/08
OR (((tbl_event.eventstart)<=[forms].[reportmenu].[startdate]) AND
((tbl_event.eventend)>=[forms].[reportmenu].[enddate])) AND
((tbl_event.sporttype)=[forms].[reportmenu].[type1]))

6) I want to see all records - e.g. every single events that we've done or
have got planned

I managed to get 1,2,3 + 6 to work but it was the 4+5 that wouldn't play fair.

regards

JAMES