Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / December 2005

Tip: Looking for answers? Try searching our database.

Probably a very simple problem, but it's got me...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Greg Murrie - 27 Dec 2005 07:23 GMT
I am trying to take a dataset that looks like this:

     Table1   Table2
ID  Work    Hours
1    abc        123
2    abc        234
3    abc        789
4    def        112
5    def        132
6    ghi        678

and write a report that writes out each Hours per work value, like this:

abc
           123
           234
           789
def
           112
           132
ghi
           678

That looks so easy, even to me. But I get absolutely nothing.

Please help!
RoyVidar - 27 Dec 2005 14:28 GMT
> I am trying to take a dataset that looks like this:
>
[quoted text clipped - 23 lines]
>
> Please help!

Unless I've completely misunderstood, when you create a report through
the report wizard, base it on a query like the one you present, then in
the "Do you want to add any grouping levels" part of the wizard, select
the "Work" field, and what you wish should be what you get.

Signature

Roy-Vidar

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.