Access_help_rob
Registered User.
- Local time
- Today, 19:41
- Joined
- Jul 3, 2003
- Messages
- 66
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
please help
thanks
rob