Results 1 to 2 of 2
  1. #1
    Rizvi is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    12

    Report design probled

    Hi,


    I have built a query having following fields
    Attendance Date
    EmpID
    UserName
    TimeIn
    TimeOut
    WorkingHours
    i am trying to build a report in below format but unable to do so, if any one can help me out

    Attendance Date should be in Columns according to the filters
    TimeIn, TimeOut & WorkingHours Field should be under each date column
    UserName should be in Rows
    for eg

    UserName. Attendance Date
    22/01/21
    TimeIn. TimeOut. WorkingHours
    xxxx 8:00 15:00. xxxxx


    if anybody can help me out it will be of great help
    thanks

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,860
    Don't use the wizard and just start with Blank report.
    Then put the controls and labels where ever you want them?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Best report design
    By slimjen in forum Reports
    Replies: 5
    Last Post: 12-04-2019, 10:28 AM
  2. How to design a report ?
    By Ucan in forum Reports
    Replies: 2
    Last Post: 02-23-2019, 11:36 AM
  3. Replies: 0
    Last Post: 07-27-2018, 02:17 PM
  4. report design
    By sunil in forum Reports
    Replies: 3
    Last Post: 01-26-2015, 11:43 AM
  5. Report Design
    By cbrsix in forum Reports
    Replies: 2
    Last Post: 06-27-2012, 07:10 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