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.