Crosstab Query Output Value Adjustment
-
- 4StarLounger
- Posts: 528
- Joined: 26 Jan 2010, 15:14
Crosstab Query Output Value Adjustment
On the startup form of the attached mdb select July 2010. QueryFermiM1 and QueryFermiM1SQL are identical but they draw their data from Access tables in one case and the same tables upsized to SQL Server in the other so while the output of QueryFermiM1 is in hours, the one from QueryFermiM1SQL is in minutes. Is there a way to make QueryFermiM1SQL show hours:minutes as well?
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78535
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Crosstab Query Output Value Adjustment
Divide the sum by 60. Don't forget to do this for the Totale column too.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 528
- Joined: 26 Jan 2010, 15:14
Re: Crosstab Query Output Value Adjustment
Thank Hans :-)