query date and greater than date

[Bill Malmgren]

I have 15 queries that I would like to change the criteria date by
referencing a separate table to set a "date" and a ">date" dates are in
two separate fields. This would eliminate the time (and error) of going
into 15 queries each day . I have been able to set up the Date in a
separate table and have the 15 queries update by referencing the single
table However the "greater than date" does not work as a look up to update
the 15 queries. When I type >2/15/2005 (for instance) the query works fine,
but will not pick it up from an other table. Appears the ">" symbol is the
problem.

Help,
Bill

 

[Ken Snell [MVP]]

You didn't post any specifics about what you're doing, but guessing that
you're putting the ">" operator character into the table with the date
string...don't do that. Operators cannot be "inserted" as characters this
way unless you build the SQL string in code.

Just write your query with the > character in it, and get the "greater than"
date value from the table.