Results 1 to 2 of 2
  1. #1
    Jeetsab is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    1

    Want to show Report?

    Hi if anyone can help me out please help,,

    Hi All,
    I am new on Access and working in Cencus Department. I created a Access Database for our department its a simple database nothing special in it. Its just showing our departments Cencus counting.
    But this counting is category wise. I created a table with such information. ID, Location, City, Assigned To, Status, Date of counting, Total Count.
    Now i want to show report on basis it. Like report by location, report by City, Report by status, Report by assigned to. Yearly report, Quarterly report and Monthly report. I am just want to filter data by fields, I created a form to and on that everything available but i m not able to prepare report and linked it with form. Please can anyone help me out to create a report.
    Thanks in advance

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    For a quick report, use the report wizard with your table.
    The wizard will ask for your sort field.

    Once you see the report, you can create some code to open a report and set the sort field(s).

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

Similar Threads

  1. How to show carton no. this way in a report?
    By DANIEL SING in forum Access
    Replies: 1
    Last Post: 10-07-2012, 12:10 PM
  2. Show all attatchments in report
    By white2golf in forum Reports
    Replies: 3
    Last Post: 07-30-2012, 12:25 PM
  3. Replies: 1
    Last Post: 01-10-2012, 03:44 AM
  4. Show report for today only
    By cooper in forum Reports
    Replies: 6
    Last Post: 09-06-2011, 12:46 PM
  5. Need report to show dates
    By Brian62 in forum Reports
    Replies: 2
    Last Post: 11-20-2009, 12:05 PM

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