Using Dates in Queries

  • Thread starter Thread starter JasonO.
  • Start date Start date
J

JasonO.

I use multiple Access 2003 queries that have hard coded criteria such as ">
9/30/2008." This is a problem because each time we roll the database we need
to update all of these hard coded dates in each query. If one query gets
missed, the data is incorrect. I would like to be able to change the date
once and have all of the queries flow from that one date change. Is this
possible? I am open to any suggestions. I am a very new to Access.

Thank you,
 
Jason

"How" depends on "what". How to modify your query/queries will depend on
what data you are using.

If all your queries start out at the same point (i.e., pulling from a single
source of data), you could use a 'parameter query' at that point to gather
the date value, then create all your other queries "pointing" at that first
one.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top