Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008
    Posts
    1

    Extremely simple ACCESS DB

    This is supposed to be really easy but I really really stink at Access. All I need is to have an ID, a Start Date, an End Date and a check box (to see if all work was completed by the end date). The table is not a problem, but when I make the form in the wizard the format comes out like this:

    ID - StartDate - EndDate - Yes/No

    Then it will automatically ask for the ID again and a new start and end date.

    What I need for it to do is only ask for the ID once, and have a record of start and end dates underneath it. I am clueless as to how to do this.



    So the format I want would look like this:
    ID
    Start Date - End Date - Yes/No
    Start Date - End Date - Yes/No
    Start Date - End Date - Yes/No
    Until however many dates I need to have entered are entered. And then I want to be able to hit new entry so that I can enter another ID and a bunch of dates. This doesn't seem difficult but I am stumped.

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109

    Something to Consider

    If you want to have multiple date entries for a given ID, you may want to have two tables and a subform. The first table would store just the ID. The second table would probably look like your current table. Create the main form based on the first table. Create a second form based on the second table. Add the second form to the first form as a subform. The two forms would link together based on the ID field.

    Hope that helps.

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

Similar Threads

  1. Simple but hard question
    By andymok in forum Reports
    Replies: 1
    Last Post: 09-20-2007, 09:19 AM
  2. Should be simple Query Question
    By brj1 in forum Queries
    Replies: 2
    Last Post: 03-04-2006, 01:11 PM
  3. Simple record lookup?
    By Transeau in forum Access
    Replies: 0
    Last Post: 01-18-2006, 10:27 PM
  4. Probably a simple report question
    By gmurrie in forum Reports
    Replies: 1
    Last Post: 12-28-2005, 09:19 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