Selection of names between specified dates.

[W. Guy Delaney]

I have a table which has a field for DateDeceased. I would like to use a
query to determine who has died from June 1 or the previous year until the
current date. What criteria can I use in my query so that I can select
everyone in my database who has died in that time frame, for example from
June 1, 2002 until August 3, 2003?

 

[Duane Hookom]

Set the criteria to:
Between DateSerial(Year(Date())-1, 6,1) And Date()

 

[_Bigred]

I would create a query and put the following:


Between [Enter Start Date] and [Enter End Date]

then after you create this query, base a form or report off this query.

Later,
_Bigred

 

[Raistlin]

** Novice Warning: I am a novice Access user, with no specialist
knowledge, please treat my answers as such **

Hi There,

I would imagine that you could use the following criteria against the
DateDeceased field in your query:

Between [Enter Start Date] And [Enter End Date]

Type it exactly as above, what should happen when you run the query is that
Access will prompt you (using the text between the two square brackets) for
the dates and then base the query on that.
Obviously make sure you include any other fields in the query that you want
shown in the results.

HTH

Raist.