Results 1 to 2 of 2

Thread: Help with Access Query

  1. Dec 1st, 2001, 06:40 AM #1
    Chris Marsden
    Chris Marsden is offline

    Thread Starter
    Member
    Join Date
    Sep 2001
    Location
    Lancashire England
    Posts
    36

    Question Help with Access Query

    How can I filter out data from the current years quarter but still allow data to be displayed from previous years quarters.
    I have been using DatePart("q",[Target Reply Date]) < DatePart("q",Date()) but this won't display previous years data.
    Chris
    Reply With Quote Reply With Quote
  2. Dec 1st, 2001, 10:11 AM #2
    egiggey
    Guest
    Hi
    couldn't you just youse a datetimepicker and allow the user to choose the dates that they want to view?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width