Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report in Access (Access 2000)

    Hi Everyone,

    I am trying to create a query based on criteria of dates. I have 2 tables one with event name id and event names field and the other table with the event name id and event dates. It is a one to many relationship.
    One event to many dates. I am trying to create a query that has event names held in January and then event name held in February and so. I would like the name of event and then date displayed.
    I am enter criteria of between 010102 AND 310102 etc and running the query and nothing is displayed.
    I have tried other ways with no luck.
    Any ideas of what to look at?

    Thanks Kindly,

    Kerrie

  2. #2
    New Lounger
    Join Date
    Nov 2001
    Location
    Virginia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report in Access (Access 2000)

    Are you enclosing date criteria as such:

    #01/01/2002#

    in the query?

    also look at format property for working/returning dates

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report in Access (Access 2000)

    Hello,

    Thanks for the date format I tried it and it worked perfectly. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> I am also to do the following. In the query the first column has the event name the second column has January's event, then in the 3 colomn I want to put February's event dates. When I setup the query to display on those event's held in January it works.
    However when I then add another column and setup the criteria to display only February - So I have event name, then dates for Jan, then dates for Feb, it displays nothing. It is as if it is comparing both columns????
    Any ideas....
    Thanks Kindly,

    Kerrie <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  4. #4
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report in Access (Access 2000)

    Hello again,

    I have worked out that whenever I try criteria using between or >= AND <=, that I get no data.
    I I use # at the end and start of the dates it give me an error "...expression is incorrect..."

    Kerrie <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    New Lounger
    Join Date
    Nov 2001
    Location
    Virginia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report in Access (Access 2000)

    Store all dates in the one column. There is no reason for a third February date column if I understand you correctly and that is what you are doing.

  6. #6
    New Lounger
    Join Date
    Nov 2001
    Location
    Virginia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report in Access (Access 2000)

    Post your criteria. It should be like:

    Between #1/1/02# and #1/31/02#

  7. #7
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report in Access (Access 2000)

    Hello again,

    The reason why I would like the 3rd column is because I want to base a report on this query.
    I would like the report to look lie the following:

    Event name January February March
    Event 1 23/01/2002 4/02/2002
    24/01/2002
    Event 2 1/02/2002 5/03/2001
    Event 3 30/01/2001 7/03/2001
    and so on

    So if the query listed the different events and their dates in different columns I would base the report on
    that. At the moment it only displays January's event and dates.
    And displays them in a report above.

    Kerrie

  8. #8
    New Lounger
    Join Date
    Nov 2001
    Location
    Virginia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report in Access (Access 2000)

    OK, base report on table or a query.

    In details section of report just place controls all on same level.

    event date1 date2


    This will display all info in table.

    Key is placing controls in report at same horizontal level.

Posting Permissions

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