Help with dates please

[Access_help_rob]

Hey there, well i have a database which shows changes made to a vehicle in our company every day, now i have been asked for a report which shows just vehicles whih were modified last week, so i created the querie and entered the criteria Between Date()-7 And Date() however, they also want me to show the vehicles which didnt have changes with a 0 in the column rather than not showing any information about that vehicle at all.
please help
thanks
rob

 

[Fuga]

How do you mean?

Do you want to show all the records?

Fuga.

 

[Ringers]

For the fields that have no record use the default value '0', which will then be over written by a record/action.