Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    3

    query problem, oppointments for one week

    Hi
    I have a table of appointments, how could I create a query to show the
    appointments for just the week ahead.

    Thanks


    Keith

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    How do you define "the week ahead"?

  3. #3
    Drainie is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2006
    Posts
    1
    Have you tried using a criteria such as:

    Between Date() And (Date() + 7)

    on your appointment date field?

    Drainie

Please reply to this thread with any new information or opinions.

Similar Threads

  1. problem with query size
    By acheo in forum Queries
    Replies: 0
    Last Post: 04-11-2007, 10:46 AM
  2. Is this a Query or Sorting problem?
    By bwrobel in forum Queries
    Replies: 2
    Last Post: 07-14-2006, 08:15 AM
  3. When Week Numbers Collide!
    By Schwagr in forum Queries
    Replies: 3
    Last Post: 03-18-2006, 10:06 PM
  4. Week number wrong
    By Nikki17 in forum Queries
    Replies: 6
    Last Post: 03-18-2006, 10:01 PM
  5. Day of Week Totals
    By ddog171 in forum Queries
    Replies: 1
    Last Post: 03-18-2006, 07:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums