Results 1 to 3 of 3
  1. #1
    LostOne is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    2

    Angry Custom Report by date then time

    I am trying to build a report in access that allows me to have my page header, and then report a daily header followed by that days hourly information. A template is attached. I have the report being queried by a form. The form queries for the ID and then the report pulls the information in regards to that ID. I do not have it specific by date yet. I am hoping to get some help on figuring out how I can get it to report in the form that I want. If needed or wanted, I can attach my mock up database.

    Thanks.



    Click image for larger version. 

Name:	Access Report Template.JPG 
Views:	6 
Size:	34.4 KB 
ID:	16515

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Your query will have some [EventDate] field. (the date/time field)
    Your report will need a group / sort on this field (show the head/footer) to sort by dates & times.

  3. #3
    LostOne is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    2
    Disregard.
    Last edited by LostOne; 05-22-2014 at 01:52 PM. Reason: No longer an issue

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Time comparison based on date - Late Report
    By gryphin81 in forum Reports
    Replies: 8
    Last Post: 04-25-2014, 11:35 AM
  2. Subtracting a date/time field from a number to get date/time
    By Lifeseeker1019 in forum Programming
    Replies: 4
    Last Post: 03-28-2014, 12:59 PM
  3. Replies: 1
    Last Post: 03-13-2014, 07:23 PM
  4. report Duplicate date many time pls help
    By shendy20007 in forum Reports
    Replies: 10
    Last Post: 10-28-2012, 07:24 PM
  5. Export Report to Excel without Date() and Time()
    By agent- in forum Import/Export Data
    Replies: 5
    Last Post: 12-21-2011, 08:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums