I know you can have a query select data between date 1 and date 2. But what can I do if I want to select records older than 2 weeks but not older than 4 weeks? And I don't want to make the user type in the dates.. Any thoughts? Thanks.

How about this in a query, put it in the criteria of the date you to filter (the date the record was created?):

Between (Date()-14) And (Date()-28)

So anything with a date between fourteen days and 28 days before today's date would appear.