Criteria on Calculated Field

[Ambre]

Hi,

I work in education and have to work with 'Academic Years' that begin August 1 and finish July 31 the following calendar year. Academic Year Aug 07 to July 08 would be known as 2007.

I need to query a database for Learners who are aged 19-25 on August 31 of the Academic year they started their learning. (I know, but this is Education!)

My query has a calculated field [Start Year] that determines which Academic year they started in based on their enrolment date. This works fine.

I have a calculated field [Age] that determines the Learner's age on August 31 [Start Year] from their DoB. This works fine.

However, when I put any criteria on the [Age] field I am prompted to enter a parameter value for Start Year! Why?

I am using Access 2007.

Any help will be much appreciated.

Ambre

 

[John Big Booty]

I can't see why that would be. Any chance you could post a copy of the DB?

 

[Ambre]

Hi John,

I'm sorry it is not possible to share the database - Data Protection issues.

Ambre

 

[John Big Booty]

Perhaps a screen shot of your query in design view.

 

[Ambre]

Hi John,

I am struggling with this.

Basically I don't know how to do what you ask. I have tried pasting screen shots into a WORD document (my usual approach) but the file size is too big to attach.

Can I email you direct?

Ambre

 

[John Big Booty]

Zip the word file and upload the Zip file.

 

[Ambre]

Hi John,

OK, here goes.

Ambre