Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Business Applications
Tag Cloud
access acer asus bios bsod computer crash desktop drive driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory missing monitor motherboard network printer problem ram random registry router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: Show dates on report heading

Reply  
Thread Tools
Brian62's Avatar
Junior Member with 6 posts.
 
Join Date: Oct 2009
20-Nov-2009, 12:19 PM #1
Solved: Show dates on report heading
I am creating a report that needs to show the beginning and ending dates to show up on the report.

Example: The report shows dates between 1/01/08 through 11/12/09 (multiple records)

The report heading would need to show: Annual Report Jan 2008 thru Oct 2009

Is there a way that I can use the dates on the report from a query to give me what I need?
The Villan's Avatar
Senior Member with 2,003 posts.
 
Join Date: Feb 2006
Location: Lincolnshire UK
Experience: Advanced at times
20-Nov-2009, 12:27 PM #2
Brian
It is important you tell us what application you are using and the version.
Brian62's Avatar
Junior Member with 6 posts.
 
Join Date: Oct 2009
20-Nov-2009, 12:28 PM #3
Sorry, it's Access 2007.
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 14,665 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
20-Nov-2009, 12:29 PM #4
Brian, yes you can with a bit of manipulation in the query.
You will need to create 2 new Column with the following headings
Start: format([Start Date], "mmm yyyy")
Finish: format([Finish Date], "mmm yyyy")

Where Start and Finish Dates are your start and finish dates, if they originate on a form you will have to include the form name like this format(forms![FormName]![Start Date], "mmm yyyy")
__________________
OBP
I do not give up easily
Brian62's Avatar
Junior Member with 6 posts.
 
Join Date: Oct 2009
20-Nov-2009, 01:48 PM #5
Worked perfectly. Thanks!
Reply

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 03:29 AM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.