Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Danbury,ct 06801
    Posts
    24

    Question Unanswered: Report Problem with date range

    i am running query out of a form and generating the report. but when i do not have info in date range than i want all the records and if there is a range than just give me the info with in that range ..

    i am not sure how to get there i try iif and many other things ..

    can some please help me

    thank you
    hbhavsar

  2. #2
    Join Date
    Feb 2004
    Location
    Swindon, UK
    Posts
    86
    i take it you have a date field within your table. then in the query, add that field as a Where. and add the following criteria

    >=[Forms]![frmDates]![datFrom] And <=[Forms]![frmDates]![datTo]

Posting Permissions

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