Parameter Query

From: berk (anonymous_at_discussions.microsoft.com)
Date: 07/31/04 

Date: Sat, 31 Jul 2004 01:39:19 -0700

in the criteria section for Beginning date, type this:
>=[Enter From Date]
in the criteria section for the ending date, type this:
    <=[Enter To Date]

Make sure you use the brackets.
>-----Original Message-----
>
>Dear all,
>
>I have two field, "Begining Date" and "Ending Date"
>
>I would like to make a paramater query to prompt the
user to key in a
>begining date and a ending date, and it will show all
the data within the
>two date range.
>
>What should I do?
>
>Thank You.
>
>Cheers!
>
>
>
>
>
>.
>

Relevant Pages

  • Re: Help with Date Parameter
    ... "Enter Business Date of Report"? ... When I run the query, records for all dates are displayed instead of just ... You need to set the query criteria to: ... Brackets will not be necessary (but are still good ...
    (microsoft.public.access.queries)
  • Re: Show Report months ontop of the report?
    ... your criteria to something like: ... You can then use a control source in your report like: ... Once from the query and once from the expression I ... "The text within the brackets MUST be identical to the bracketed text ...
    (microsoft.public.access.reports)
  • Re: Query Date Range Criteria Doesnt Include Last Date in Range
    ... The "Too complicated" error message can mean things like this: ... The criteria are malformed, e.g. the brackets don't match. ... Access is misunderstanding the SQL statement, e.g. if you have a field ...
    (microsoft.public.access.queries)
  • Re: HOW TO INPUT AND/OR INTO A SQL WHERE CLAUSE FROM A COMBO BOX
    ... brackets to make sure that there is no odd one. ... criteria on the first 2 lines of the criteria in the ProcessedDate field put ... the SortCode Crteria on the same 2 lines in the SortCode field and the Text19 ... FROM CCandBank ...
    (microsoft.public.access.queries)
  • Re: Multiple criteria in COUNTIF in Excel
    ... brackets in column B: ... > Above compares the data with only one criteria. ... > student marks in a Physics course: ...
    (microsoft.public.excel.worksheet.functions)