I'm fairly new to Access and having a spot of bother

I want one of my forms (that is based on a query) to open and display all records created in the last two weeks, based on a field which only has a date() input, (time isn't recorded)

I imagine this is probably easy enough, I just cant think how to do it

Help ! please

Add the condition

Between DateAdd("ww", -2, Date()) And Date()

in the Criteria row of your Date Field/Column in the Query Design grid.