Questtons

[Guest]

Each year I records how many applications we receive. Each time i get a new
application I record the date I received it....

Im just wondering, is there a way to ask my databse to tell me how many
applications we received up until say 22-Oct-06?
And then if i later went back and asked how many we received up until say
22-Nov-06? Is there a way to do this?

Thanks.

Claire

 

[Rick Brandt]

Each year I records how many applications we receive. Each time i get a new
application I record the date I received it....

Im just wondering, is there a way to ask my databse to tell me how many
applications we received up until say 22-Oct-06?
And then if i later went back and asked how many we received up until say
22-Nov-06? Is there a way to do this?

A totals query.

SELECT Count(*)
FROM TableName
WHERE [DateField] < #23-Oct-2006#

 

[Douglas J. Steele]

SELECT Count(*) As NumberOfApplications
FROM MyTable
WHERE ReceiptDate <= [What date?]

Replace MyTable and ReceiptDate with the actual names.

That's the actual SQL you need. To create that query using the GUI, go to
create a new query. Select your table from the list that's present, and
click OK.

In the grid underneath the table, type

NumberOfApplications: Count(*)

into the Field cell of the first column.

Drag the appropriate date field from the table into the Field column of the
second column, and uncheck the check box underneath it.

In the Criteria row underneath the date field, type

[What date?]

That's it.