Results 1 to 10 of 10

Thread: comparing dates resolved

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2005
    Posts
    334

    comparing dates resolved

    i have a table that contains dates and rates, i want to create a query which returns the rate corresponding to todays date or the closest date in the past

    (i know how to say select where date = a certain date but how do i do the above???)

    any ideas????
    Last edited by pame1la; Apr 11th, 2005 at 06:54 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width