Results 1 to 3 of 3
  1. #1
    Jasrenkai is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Feb 2011
    Posts
    8

    Not sure how to approach this problem

    I recently got some very useful and precise help from these forums...that worked well. So I figured I'd cast my line out here first. I do not know the best way or rather most effecient way to go about an issue that I have come across. It relates to the help that I recently got but here is the basis.



    I have a table that has this information

    Date | Name | Start_Time | Event


    There are a bunch of queries that i've had to set up, and there is one that I do not know if it is even possible or what I will have to do to get it to work. But it goes something like this. I need the next Start_Time for the direct chronologically next event, in a seperate Column with no Date carryover, and no person carryover. So at each change in Date and/or Name, do not record the next start_time.

    Date | Name | Start_Time | Next_Start_Time | Event

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    you have to use recordsets in code. you can't do it otherwise (if I'm reading this right).

    you can't perform vertical manipulations in queries through the interface alone.

  3. #3
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Seeing as though you want the time of the very next next event associated with the current one, I asume there is a correlation between Start_Time and Next_Start_Time. Is this calculable? For example, will event n always start x time after event n-1? If so, you don't even need to store it. Just calculate it on the fly.

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

Similar Threads

  1. Programming Approach for Pattern Layouts
    By IvoryDragonfly in forum Programming
    Replies: 3
    Last Post: 10-09-2010, 01:14 AM
  2. Replies: 2
    Last Post: 06-14-2010, 03:25 PM
  3. query problem i have a problem wi
    By maxx3 in forum Queries
    Replies: 0
    Last Post: 06-29-2009, 02:29 AM
  4. Best approach to export to HTML in this scenario
    By techguy817 in forum Import/Export Data
    Replies: 0
    Last Post: 04-17-2009, 10:28 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