Re: date problem

"kevcar40" <kevcar40@xxxxxxxxxxxxxx> wrote in message
news:1130249184.335712.271310@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> hi
> i have a table that contains a date the record was created
> after three months i want to review the record and enter a review date
> (no Problem so far)
>
> i now query the table adding a field(test) that takes the review date
> and adds 90 to it(3 months approx)
>
> i have now another query that looks at the field test and compares it
> to current date this is returning a record with a 22/01/2007 date
> value, in the query i have used <date()
>
> What i want is to return only the records that require reviewing
> ie current date 25/10/2005 review date 24/10/2005
> can anyone help please
>
>
Hi Kevin, just a minor nit-pick but it would make your posting that much
easier to understand with some full stops and caps :o)

I've just simulated the scenario you describe and using "<Date()" for
criteria in the calculated field it appears to work correctly. Are you sure
you have the criteria against the right (calculated) field? Is your stored
date value a "date" data type in the table?

Regards,
Keith.
www.keithwilby.com


.

Relevant Pages

  • Re: Converting bad table design to good design
    ... There isn't really a whole lot to learn about append queries. ... query) they are queries like any other. ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... >>> Category for review ...
    (microsoft.public.access.externaldata)
  • Re: Need Help with Formula Expansion
    ... Hash: SHA1 ... You could just ask for the start date and how many months the query ... I ask becuase there are times when the users would only need the results for only 2 Review Dates, ...
    (microsoft.public.access.queries)
  • RE: Query Criteria Help!!!
    ... It would be better if I could run a report on this information. ... review process is closed at that date). ... > A work around for your query is as follows. ... > Use the QBE query grid and in the first row of the criteria completed 1 ...
    (microsoft.public.access.queries)
  • RE: Linking a Combo box to variable SQL query in subform
    ... to pass a criteria to a query from a form; you need to reference the correct ... Form control in the query's criteria: ... tbl_ReviewHearder, the second, ...
    (microsoft.public.access.forms)
  • Need help to structure simple (I think) query...
    ... For ALL the Reviews associated with a Document, there can be only ONE Review ... So I want to structure a query that will identify the Document IDs that fit ... but I want only the Document records where there is more than one ... I tried a crosstab query like this: ...
    (microsoft.public.access.queries)
Loading