Results 1 to 5 of 5

Thread: Date Criteria

  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    New Orleans, Louisiana
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Criteria

    I am using Access 97 on Windows 98. I am trying to create a report to show total sales for the month and total sales for the year for each sales rep. I created a report based on a query that totals the sales per rep for the month. I included a subreport based on a different query to total the sales ytd. I tried creating a dialog box asking for the beginning date and ending date but how do I accomplish this when I am looking for both mtd & ytd figures?

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Criteria

    in the query for the sales rep put
    <pre>between [enter start date] and [enter ending date]
    </pre>

    in the criteria of the date field
    since the year to date is a separate query it shouldn't bother it

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    New Orleans, Louisiana
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Criteria

    Thanks Jerry for your quick response. I forgot to mention that the ytd query also asks for criteria in the date field. The sales reps can log sales until close of business on the last day of the month. So if on June 2 I run the report for mtd & ytd totals, I only want ytd up to May 31. So I need to ask for beginning date and ending date for both the month and the year. This is where I ran into trouble. Hope you can make sense of out this.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Criteria

    you can put the same criteria in the other query but it will prompt twice for input
    is the year to date a set period like jan 1 to now

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    New Orleans, Louisiana
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Criteria

    The ytd is "Between #01/01/01# And [Ending Date]" but it prompts three times for the ending date.

Posting Permissions

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