Trying to get a report from a query (only records with specific dates)

  • Thread starter Thread starter Jette
  • Start date Start date
J

Jette

I am trying to print a report of all Company details
(except for those who have joined or left our Association
in 2004).
I do not understand how to write an expression which will
let me do this.
I need the report to only include dates without 2004 in
them.
Can anyone help me???

Please e-mail me!
 
I am trying to print a report of all Company details
(except for those who have joined or left our Association
in 2004).
I do not understand how to write an expression which will
let me do this.
I need the report to only include dates without 2004 in
them.
Can anyone help me???

Please e-mail me!
Click to expand...
Make a query the record source for the report.
In the query, add a new column:
Exp:Year([DateField])
As criteria for this column, write
<> 2004
You can uncheck the Show check box.

If you think you will repeat this query next year, excluding 2005
records, change the above criteria to:
<>[Enter Year not wanted]
You will get a prompt for the year to be excluded.
 
Back
Top