Results 1 to 5 of 5
  1. #1
    DiscoverIT is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Apr 2017
    Posts
    2

    Reporting In Grid Format

    Hello,

    I am trying to produce a report in a grid format similar to the enclosed screen dump at the bottom.

    Basically, I have a table of names and days attended, which through a query I have deselected the "Staff" and be left with "Clients" only.

    I am having trouble in producing a report in a grid format that show the names under each day attended.

    I can do the titles, footers and grid lines etc.

    Can somebody help me with the selecting and grouping that I am trying to achieve within Access to produce my report (The Word part is designed to show you what I am trying to achieve).

    Thank you and regards



    DiscoverIT
    Attached Thumbnails Attached Thumbnails Screen Dump.png  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Create a query to produce the items in the report...
    Ken green, Mon
    bob smith, Wed

    then use the query wizard to create a CROSSTAB query using the query above as source,
    select the items to make your report.

  3. #3
    DiscoverIT is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Apr 2017
    Posts
    2
    Thank you ranman256 for your prompt reply and I am not sure where you got bob smith from?

    What fields are you proposing to use to produce the first query because I have got three fields for Mon, Wed and Thu?

    Regards

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you may want to make a 7 queries, 1 for each day

    Q1 =select name, Iif([mon],"Mon","") from table where date between date1 and date2
    Q2=select name , IIF([tue],"tue","") from table where date ...
    etc

    then put them all together in a single UNION query, qnUnion
    select * from Q1
    union
    select * from Q2
    union
    etc


    then make the crosstab query, using qnUnion query.
    then

  5. #5
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    A Crosstab query will will not give you what you want.

    I do sample report using a sub report for each column. In your case you would have a sub report for each day. Each ruport would filter to the record where that day is checked (true).

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

Similar Threads

  1. snap to grid
    By ntambomvu in forum Access
    Replies: 1
    Last Post: 11-16-2016, 08:16 AM
  2. Replies: 7
    Last Post: 09-19-2014, 07:29 AM
  3. Looking for Grid Control
    By DJDJDJDJ in forum Access
    Replies: 4
    Last Post: 07-20-2012, 04:03 PM
  4. Grid lines vs Grid Dots
    By dharriet in forum Access
    Replies: 0
    Last Post: 10-14-2008, 09:17 PM
  5. Grid Control - or something like that.
    By rhunt in forum Programming
    Replies: 1
    Last Post: 12-15-2005, 04:46 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