Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

creating report from table

Hello,
have attached a sample db.
if you look at the table [tblFinal]
I need to create a report from that table- that displays like rptTest-but that works-
I created a crosstab query to create this report- but not sure this is how to do this-
in rptTest- i have a total field that is empty
i need a total field column to total all the weeks totals for each record.
and am trying to capture 1 week of data in report-
thankyou

db1.mdb
0
davetough
Asked:
davetough
2 Solutions
 
Khalid Mehmood AwanCommented:
Try this query...


SELECT  name,  round( sum(totalhours) , 2)
FROM tblFinal Group by  name


You can use this query to create a report.
For testing this query Goto Create then Query Design then add table then right click on query name (small tab) and goto SQL view.
0
 
Jeffrey CoachmanMIS LiasonCommented:
The issue with Crosstab "Reports" is that they hardcode the column headings

This means that if you run the report and 8/21/2011 is not in the dataset, the report will fail.
The same issuse arises when you have a new date, since it is not in the original report, it will fail.
See here for more info:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24577123.html

You can create a "Dynamic" Crosstab report though...
http://support.microsoft.com/kb/328320
...But this is way too complex IMHO.

It might just be best to leave it as a crosstab query.

Finally an alternative may be to do this in a Pivot table.

JeffCoachman
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now