Query using a date

[Stefan.Doyle]

So i have a database set up using the following;

ID
First Name
Surname


Employee Number
L1 Training
L1 Training Complete
L1 Training Refresh
L2 Training
L2 Training Complete
L2 Training Refresh

I would like to create a query that shows the results of a search using L1 Training Refresh, but i would like to show results where that date is withing a week of the search.

So if i was to use the search today it would show any results where the date is 13/11/16 through to 20/11/16.

Is there a way of doing this? I'm abit of a new comer to access.

Thanks for any help in advance

[Micron]

There are a few ways to do this, depending on how you are providing the date now. Before going too much farther, you might want to think about your design. There are clues in your post that suggest that there are or will be name issues and normalization. I say that because you appear to be using spaces in your names, using reserved words for names, and it looks like you have unrelated data in the same table. I/we can provide some links for further guidance on that if you need them.
To simply answer your question, I'll presume you are only supplying the beginning date as a date from your table (which also should not be in there). In that case, the DateAdd function should do what you want. The second date would be
DateAdd("d", 7, [someDate]) or DateAdd("ww",1,[someDate])