Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Location
    Kent
    Posts
    59

    Unanswered: Different Query problem

    Hi
    Another problem

    Im trying to design a query to return client info for a week at a time,

    The query i have at the moment is a simple one that prompts me for a start date and then it prompts me for an end date. ie start date 28/06/04 and
    end date 2/7/04.

    I still want the query to prompt me for a start date but is there anyway to set the query up so that it knows the end date is 4 / 5 days later.

    The query i got at the mo is:
    Between [Week Beginning] And [Week Ending]

    Is there a way to get it to add 5 days to start date and use the results as the end date. ie Between [Week Beginning] And [Week Beginning]+5

    Im pretty new to access but im enjoying the chalange.

    Thanks for any help in advance

    Icerat

  2. #2
    Join Date
    Mar 2004
    Posts
    41
    Looks like you're on the right track. Something else to consider: You can use Date() to have the query use today's date. I use that and Date()+7 for a week's projections on inventory. Works quite well.

  3. #3
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Select *
    from tableA
    where columnA Between [startDate] AND DateAdd("d", 5, [startDate])

    Thank You.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  4. #4
    Join Date
    Jul 2004
    Location
    Kent
    Posts
    59

    Smile

    HI
    All i can say is many many many many thanks, it works, this has been driving up the wall for days, who could have thought it could have been so simple.

    Is there a way to get the query to run from a form.

    Anyone know of any good sites i could go to to learn this stuff, that are in plain english.

    Many thanks again.

    Icerat

Posting Permissions

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