Calculating Dates

[AJ0424]

Hi,


I am really new to doing anything in Access that isn't drag and drop (although I do have some minimal SQL experience) and I am having some difficulties with dates.

I have a table with 5 columns of data. One field is "Date Entered". I want to create a query that only grabs the data where Date Entered is greater than or equal to 3 weeks.

Any help would be appreciated - please be specific, like I said, I am new!

Thanks,
AJ


Edited to Add:
Never mind....I thought I had to do this in code but <Date()-21 in the query criteria seems to work.

[RuralGuy]

Do you want to want to use the thread tool to mark this thread as Solved?