Date Range - current week

Hello Listers,

I have a database listing cars. I want a tab that shows vehicles 'inputed' in the last 7 days.

Can anyone help me with this statement?

Thanks in advance.

/john
select [ID],

[Series],

[ST#],

[YEAR],

[MODEL],

[MILES],

[COLOR],

[INTERIOR],

[TRANS],

[OPTIONS],

[OPTIONS2],

[OPTIONS3],

[OPTIONS4],

[OPTIONS5],

[OPTIONS6],

[CPO],

[PRICE],

[NOTES],

[Inputed]

From [USED INVENTORY]