Re: query for tag renewal

Tech-Archive recommends: Fix windows errors by optimizing your registry

I created the query and in the tagexpiration field criteria I inserted the
following:

Between [tagexpiration] And DateAdd("m",1,[tagexpiration])

The above criteria gave me all tagexpirations in the table.

I'm assuming in the criteria you gave me I was suppose to enter the field
name where Date() was listed. Apparently, this was not correct?

When I entered the criteria as you provided I didn't get any records, I made
sure there were records that had the tagexpiration date for at least 03/2007
and also 04/2007 but still no records returned.

The tagexpiration date is not a calculated field.

--
Todd


"BruceM" wrote:

I don't understand your question. You have a date field (I will call it
ExpDate). When you make a query based on the table containing ExpDate, and
you put the criteria I provided into ExpDate, the query will return only
those records with an expiration date (that is, the date in the ExpDate
field) that is between today and a month from today.
Is ExpDate a calculated field?

"Todd" <tak@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:67EAF722-73C3-4764-ABFD-EF0E5FDE9D18@xxxxxxxxxxxxxxxx
Thanks for the info. It did work but my problem is that for each month
separate records are entered on each vehicle. When the query shows the
results it will show expiration dates from the previous years where the
tag
had expired before. Any suggestions on how to only search for the most
recent tag expiration date?
--
Todd


"BruceM" wrote:

Build a query based on the table. Set the criteria in the date field:
Between Date() And DateAdd("m",1,Date())
This will filter for just those records where the expiration date is
between
today and a month from today. See Help for more information about
DateAdd.
You could use the query as the Record Source for a form or report.

"Todd" <tak@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F2599C07-3B4B-4F99-BC63-DB2C98BA1BF6@xxxxxxxxxxxxxxxx
I was mistaken on my explanation previously. The field in table1 is for
tagexpiration (for when the tag is due renewal), not when the tag was
purchased.--
Todd






.

Relevant Pages

  • Re: query for tag renewal
    ... You will see all records with an expiration date in that range. ... The above criteria gave me all tagexpirations in the table. ... When you make a query based on the table containing ExpDate, ...
    (microsoft.public.access.queries)
  • Re: query for tag renewal
    ... I thought maybe the date format I had for tagexpiration field was ... Therefore the criteria when you run the query today is: ... You will see all records with an expiration date in that range. ... When you make a query based on the table containing ExpDate, ...
    (microsoft.public.access.queries)
  • Re: query for tag renewal
    ... "BruceM" wrote: ... If it is a date field, the criteria should work. ... Therefore the criteria when you run the query today is: ... The tagexpiration date is not a calculated field. ...
    (microsoft.public.access.queries)
  • Re: Criteria: After This Year (oops)
    ... Try the following in your criteria for the field ... Field: ExpDate ... I would like to create a query in which the ... if the expiration date is this ...
    (microsoft.public.access.queries)
  • constant date criteria
    ... In many queries, I use the following criteria for to select ... that I only need to change the value of "ExpDate" in order to change the ... Do I have to declare "ExpDate" somewhere in the query? ...
    (microsoft.public.access.reports)