Hey everyone. How can you get your header on a report to say "Activity From" and then display the last 7 days? So if i were to read it today it would say "Activity From 5/23/12 to 5/30/12"
Thanks in advance
Report Timeline
Advanced Beginner
Windows 7 64bit 
Access 2003
Hey everyone. How can you get your header on a report to say "Activity From" and then display the last 7 days? So if i were to read it today it would say "Activity From 5/23/12 to 5/30/12"
Thanks in advance
Who is John Galt?
Windows XP Access 2007
Try
="Activity From " & Date() - 7 & " to " & Date()
Advanced Beginner
Windows 7 64bit Access 2003
Worked, Thanks!!
Who is John Galt?
Windows XP Access 2007
Duplicate a business form in an Access Report (add blank records to a report)
Posting Permissions
Reply With Quote