Prev: crosstab for day of week
Next: How to make a query sort randomly each time it is run?
From: dar on 26 Apr 2010 11:37
I would like to run a qry that will show me when my insurance policyies
expire. Some expire in 30 days others in 90.

Table: Customers
Fields:
CustomerName
ContactName
PolicyNumber
PolicyExpirationDate
From: Dorian on 26 Apr 2010 12:41
SELECT * FROM Customers where PolicyExpirationDate >= Date() ORDER BY
PolicyExpirationDate
This will list the future expiration dates but ignore those that have
already passed.
Assumes 'PolicyExpirationDate' is a date/time column.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"dar" wrote:

> I would like to run a qry that will show me when my insurance policyies
> expire. Some expire in 30 days others in 90.
>
> Table: Customers
> Fields:
> CustomerName
> ContactName
> PolicyNumber
> PolicyExpirationDate
From: John W. Vinson on 26 Apr 2010 12:40
On Mon, 26 Apr 2010 08:37:01 -0700, dar <dar(a)discussions.microsoft.com> wrote:

>I would like to run a qry that will show me when my insurance policyies
>expire. Some expire in 30 days others in 90.
>
>Table: Customers
>Fields:
>CustomerName
>ContactName
>PolicyNumber
>PolicyExpirationDate

30 or 90 days from when? How (based on the information in the table) can you
tell which policy is 30 and which is 90? More information please!
--

John W. Vinson [MVP]
From: dar on 26 Apr 2010 13:36
The PolicyExpirationDate will have a date of when the Policy will expire.
The policy may expire in August or November. i want to run a qry that will
show me up coming policies that will expire at any given time.

"John W. Vinson" wrote:

> On Mon, 26 Apr 2010 08:37:01 -0700, dar <dar(a)discussions.microsoft.com> wrote:
>
> >I would like to run a qry that will show me when my insurance policyies
> >expire. Some expire in 30 days others in 90.
> >
> >Table: Customers
> >Fields:
> >CustomerName
> >ContactName
> >PolicyNumber
> >PolicyExpirationDate
>
> 30 or 90 days from when? How (based on the information in the table) can you
> tell which policy is 30 and which is 90? More information please!
> --
>
> John W. Vinson [MVP]
> .
>
From: John W. Vinson on 26 Apr 2010 15:43
On Mon, 26 Apr 2010 10:36:01 -0700, dar <dar(a)discussions.microsoft.com> wrote:

>The PolicyExpirationDate will have a date of when the Policy will expire.
>The policy may expire in August or November. i want to run a qry that will
>show me up coming policies that will expire at any given time.

Then create a query with an appropriate criterion on the PolicyExpirationDate.
For instance, if you want to find which policies expire between today and a
week from today, use a criterion

>= Date() AND <= Date() + 7

--

John W. Vinson [MVP]
 |  Next  |  Last
Pages: 1 2 3
Prev: crosstab for day of week
Next: How to make a query sort randomly each time it is run?