Crosstab Query Output Value Adjustment

grovelli
4StarLounger
Posts: 528
Joined: 26 Jan 2010, 15:14

Crosstab Query Output Value Adjustment

Post by grovelli »

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.
Top
User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Crosstab Query Output Value Adjustment

Post by HansV »

Divide the sum by 60. Don't forget to do this for the Totale column too.
Best wishes,
Hans
Top
grovelli
4StarLounger
Posts: 528
Joined: 26 Jan 2010, 15:14

Re: Crosstab Query Output Value Adjustment

Post by grovelli »

Thank Hans :-)
Top

Return to “Access/SQL and other database applications”