Find record not updated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that looks like this "RouteNo" "<>Date()-30". The data that
I get are all the route that have been updated in the last 30 day but what I
am tring to find are the routes that have not been. What must I change to
get that information
 
Nick,

You will need to provide a lot more detailed information about your
tables and fields, and the meaning of your query, before anyone will be
able to offer useful advice.
 
It looks like you are identifying routes that have not been updated on the
30th day, and not before 30 days . ..
Ditto Steve's comments.
 
The table is a running history of actions date they were updated. Their
isn't much else to describe. I not sure what other information you need.
Please help me with this.
 
Nick

In order to know what other information to provide when asking for help
in a newsgroup, I feel it is a good idea if you try to put yourself in
the shoes of the person reading your post. Then ask yourself what
information about your database would give that person a working picture
of what you are doing. To get you started: Names of tables that are
relevant to the question, and relationships between them, names of
fields and descriptions of the data that is in them, examples of data,
maybe descriptions of when and how the data is added to the table, SQL
view of queries if your question concerns queries, along with
description of the query's purpose. Get the idea?
 
Back
Top