Styjun

How can I use 400 ASA film in a Leica IIIf, which does not have options higher than 100?

What should I wear to go and sign an employment contract?

Does science define life as "beginning at conception"?

Filter a file list against an integer array?

What to call a small, open stone or cement reservoir that supplies fresh water from a spring or other natural source?

What Species of Trees are These?

Vehemently against code formatting

Does George B Sperry logo on fold case for photos indicate photographer or case manufacturer?

Is presenting a play showing Military characters in a bad light a crime in the US?

Mikrokosmos, BB 105, Vol. 1: No. 17 Contrary Motion (1) - Can't understand the structure

Department head said that group project may be rejected. How to mitigate?

Do most Taxis give Receipts in London?

pwaS eht tirsf dna tasl setterl fo hace dorw

How to play vs. 1.e4 e5 2.Nf3 Nc6 3.Bc4 d6?

Circuit construction for execution of conditional statements using least significant bit

Which one of these Isp's for the Dawn spacecraft is wrong?

Why does an injection from a set to a countable set imply that set is countable?

Way of refund if scammed?

How do we properly manage transitions within a descriptive section?

why "American-born", not "America-born"?

Removing Doubles Destroy Topology

Requirement for splicing neutrals in a switch

Expand a hexagon

Was murdering a slave illegal in American slavery, and if so, what punishments were given for it?

How to place 3 continuous row in to the 3 stacked row in single access report

Difficult MS Access Query - how to combine them?Reconciliation Ms Access records VBA and generate error messagePlacing different rows in successionHow can I Create a Multi-Value CrossTab Query in Access 2013?show employees' salary history by adding StartingSalary and Increase values AccessGenerate Access report from multiple queriesCreating Columns And Rows On Access ReportHow to generate filtered report for records of all employees in table.in accessHow to calculate employment year based on hire date in MS AccessAccess 2016 report - sum all textboxes that sum another set of data

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

-4

I have multiple employee's salary data in tabular format for different months as displayed in the 3rd and 2nd image. (Presently extracted for a single employee in the following images example). There are 35 salary fields/columns for each employee and salary heads are different for different type of job profile. 3rd and 2nd images represent salary data table for all job profile employee. Because the table has many columns so I posted only two part of a single table in third and second images. There are also other fields which have 0 values or more than 0 as per the employee's job profile. I created a query to extract quarterly data for a single employee from the table as per the third and second images.

The first image is the result, which I want to arrange as the stacked format. Presently my report showing only single month data in the this report. There is report load event code to show only heads which have values more than 0 as following:

Dim C As Control

For Each C In Me.Report

If TypeOf C Is TextBox Then

 If IsNull(C) Or C = "" Or C = 0 Or C = "0" Then
 C.Visible = False
 C.Height = 0
 Else
 C.Visible = True
 End If
End If

I want to display the result as per the report images as follows. Is it possible to place 3 stacked column? thanks for the help and any suggestions.

Example images:

ms-access ms-access-reports

share|improve this question

edited Mar 24 at 7:49

mukeshesic

asked Mar 23 at 15:53

mukeshesicmukeshesic

58

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The example that you tried to provide is not accessible.
  
  – IgorM
  Mar 23 at 15:58
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  igorM.. Example link working
  
  – mukeshesic
  Mar 23 at 15:59
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  So what is the actual question? Is the only problem getting the data in quarterly groups? The images are not very useful, because the column names are very cryptic and the columns do not include any date values. The question indicates that the "Second image" has something to do with printing quarterly data on a single page, but it only has a bunch of zero values... seems to me completely useless. Finally, it is expected on Stackoverflow to show what you have tried and why it is not working. Do not just post requirements and ask for a solution.
  
  – C Perkins
  Mar 23 at 19:15
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  C perkins, i edited my question to clear my query. Thanks for any suggestion
  
  – mukeshesic
  Mar 24 at 2:45
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @user2245124 If you want to notify a certain user of a comment, type @ followed by the username... just as I did for your username. Otherwise they may never know that you responded. Click on the help link next to the comment box for more info.
  
  – C Perkins
  Mar 24 at 6:54
  

  
  
  
  

 | 
show 4 more comments

-4

I have multiple employee's salary data in tabular format for different months as displayed in the 3rd and 2nd image. (Presently extracted for a single employee in the following images example). There are 35 salary fields/columns for each employee and salary heads are different for different type of job profile. 3rd and 2nd images represent salary data table for all job profile employee. Because the table has many columns so I posted only two part of a single table in third and second images. There are also other fields which have 0 values or more than 0 as per the employee's job profile. I created a query to extract quarterly data for a single employee from the table as per the third and second images.

The first image is the result, which I want to arrange as the stacked format. Presently my report showing only single month data in the this report. There is report load event code to show only heads which have values more than 0 as following:

Dim C As Control

For Each C In Me.Report

If TypeOf C Is TextBox Then

 If IsNull(C) Or C = "" Or C = 0 Or C = "0" Then
 C.Visible = False
 C.Height = 0
 Else
 C.Visible = True
 End If
End If

I want to display the result as per the report images as follows. Is it possible to place 3 stacked column? thanks for the help and any suggestions.

Example images:

ms-access ms-access-reports

share|improve this question

edited Mar 24 at 7:49

mukeshesic

asked Mar 23 at 15:53

mukeshesicmukeshesic

58

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The example that you tried to provide is not accessible.
  
  – IgorM
  Mar 23 at 15:58
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  igorM.. Example link working
  
  – mukeshesic
  Mar 23 at 15:59
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  So what is the actual question? Is the only problem getting the data in quarterly groups? The images are not very useful, because the column names are very cryptic and the columns do not include any date values. The question indicates that the "Second image" has something to do with printing quarterly data on a single page, but it only has a bunch of zero values... seems to me completely useless. Finally, it is expected on Stackoverflow to show what you have tried and why it is not working. Do not just post requirements and ask for a solution.
  
  – C Perkins
  Mar 23 at 19:15
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  C perkins, i edited my question to clear my query. Thanks for any suggestion
  
  – mukeshesic
  Mar 24 at 2:45
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @user2245124 If you want to notify a certain user of a comment, type @ followed by the username... just as I did for your username. Otherwise they may never know that you responded. Click on the help link next to the comment box for more info.
  
  – C Perkins
  Mar 24 at 6:54
  

  
  
  
  

 | 
show 4 more comments

I have multiple employee's salary data in tabular format for different months as displayed in the 3rd and 2nd image. (Presently extracted for a single employee in the following images example). There are 35 salary fields/columns for each employee and salary heads are different for different type of job profile. 3rd and 2nd images represent salary data table for all job profile employee. Because the table has many columns so I posted only two part of a single table in third and second images. There are also other fields which have 0 values or more than 0 as per the employee's job profile. I created a query to extract quarterly data for a single employee from the table as per the third and second images.

The first image is the result, which I want to arrange as the stacked format. Presently my report showing only single month data in the this report. There is report load event code to show only heads which have values more than 0 as following:

Dim C As Control

For Each C In Me.Report

If TypeOf C Is TextBox Then

 If IsNull(C) Or C = "" Or C = 0 Or C = "0" Then
 C.Visible = False
 C.Height = 0
 Else
 C.Visible = True
 End If
End If

I want to display the result as per the report images as follows. Is it possible to place 3 stacked column? thanks for the help and any suggestions.

Example images:

ms-access ms-access-reports

share|improve this question

edited Mar 24 at 7:49

mukeshesic

asked Mar 23 at 15:53

mukeshesicmukeshesic

58

Dim C As Control

For Each C In Me.Report

If TypeOf C Is TextBox Then

 If IsNull(C) Or C = "" Or C = 0 Or C = "0" Then
 C.Visible = False
 C.Height = 0
 Else
 C.Visible = True
 End If
End If

share|improve this question

edited Mar 24 at 7:49

mukeshesic

asked Mar 23 at 15:53

mukeshesicmukeshesic

58

share|improve this question

edited Mar 24 at 7:49

mukeshesic

asked Mar 23 at 15:53

mukeshesicmukeshesic

58

asked Mar 23 at 15:53

mukeshesicmukeshesic

58

asked Mar 23 at 15:53

mukeshesicmukeshesic

58

1 Answer
1

active

oldest

votes

0

You can implement the following SQL query to a salary per employee per quarter considering that your table contains only one-year salaries

 SELECT
 EmployeeName
 ,SUM(IIF(Month([DateColumn]) BETWEEN 1 AND 3, Salary, 0)) AS Salary_Q1
 ,SUM(IIF(Month([DateColumn]) BETWEEN 4 AND 6, Salary, 0)) AS Salary_Q2
 ,SUM(IIF(Month([DateColumn]) BETWEEN 7 AND 9, Salary, 0)) AS Salary_Q3
 ,SUM(IIF(Month([DateColumn]) BETWEEN 10 AND 12, Salary, 0)) AS Salary_Q4
FROM TblSalary
GROUP BY EmployeeName 

share|improve this answer

edited Mar 23 at 16:16

answered Mar 23 at 16:07

IgorMIgorM

489517

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  MS Access does not have CASE WHEN, you'll need to use SWITCH or IIF.
  
  – Lee Mac
  Mar 23 at 16:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @LeeMac, correct. Fixed my answer. Thanks
  
  – IgorM
  Mar 23 at 16:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You could also use iif(datepart("q", datecolumn)=1, Salary, 0) etc. as an alternative.
  
  – Lee Mac
  Mar 23 at 16:43
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @igorM... I think, you could not understand my issue.. i can group query but issue is to put up 3 months row fields to three columns in single report.. each report for each employee.. see images
  
  – mukeshesic
  Mar 23 at 18:09
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @user2245124 the easiest way to pull out the months is usually a crosstab query. get everything else done then make the bottom of the report a sub report and bind to a crosstab query. There are lots of tutorials online under crosstab and access
  
  – mazoula
  Mar 25 at 5:15
  

  
  
  
  

 | 
show 3 more comments

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55315576%2fhow-to-place-3-continuous-row-in-to-the-3-stacked-row-in-single-access-report%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You can implement the following SQL query to a salary per employee per quarter considering that your table contains only one-year salaries

 SELECT
 EmployeeName
 ,SUM(IIF(Month([DateColumn]) BETWEEN 1 AND 3, Salary, 0)) AS Salary_Q1
 ,SUM(IIF(Month([DateColumn]) BETWEEN 4 AND 6, Salary, 0)) AS Salary_Q2
 ,SUM(IIF(Month([DateColumn]) BETWEEN 7 AND 9, Salary, 0)) AS Salary_Q3
 ,SUM(IIF(Month([DateColumn]) BETWEEN 10 AND 12, Salary, 0)) AS Salary_Q4
FROM TblSalary
GROUP BY EmployeeName 

share|improve this answer

edited Mar 23 at 16:16

answered Mar 23 at 16:07

IgorMIgorM

489517

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  MS Access does not have CASE WHEN, you'll need to use SWITCH or IIF.
  
  – Lee Mac
  Mar 23 at 16:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @LeeMac, correct. Fixed my answer. Thanks
  
  – IgorM
  Mar 23 at 16:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You could also use iif(datepart("q", datecolumn)=1, Salary, 0) etc. as an alternative.
  
  – Lee Mac
  Mar 23 at 16:43
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @igorM... I think, you could not understand my issue.. i can group query but issue is to put up 3 months row fields to three columns in single report.. each report for each employee.. see images
  
  – mukeshesic
  Mar 23 at 18:09
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @user2245124 the easiest way to pull out the months is usually a crosstab query. get everything else done then make the bottom of the report a sub report and bind to a crosstab query. There are lots of tutorials online under crosstab and access
  
  – mazoula
  Mar 25 at 5:15
  

  
  
  
  

 | 
show 3 more comments

0

You can implement the following SQL query to a salary per employee per quarter considering that your table contains only one-year salaries

 SELECT
 EmployeeName
 ,SUM(IIF(Month([DateColumn]) BETWEEN 1 AND 3, Salary, 0)) AS Salary_Q1
 ,SUM(IIF(Month([DateColumn]) BETWEEN 4 AND 6, Salary, 0)) AS Salary_Q2
 ,SUM(IIF(Month([DateColumn]) BETWEEN 7 AND 9, Salary, 0)) AS Salary_Q3
 ,SUM(IIF(Month([DateColumn]) BETWEEN 10 AND 12, Salary, 0)) AS Salary_Q4
FROM TblSalary
GROUP BY EmployeeName 

share|improve this answer

edited Mar 23 at 16:16

answered Mar 23 at 16:07

IgorMIgorM

489517

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  MS Access does not have CASE WHEN, you'll need to use SWITCH or IIF.
  
  – Lee Mac
  Mar 23 at 16:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @LeeMac, correct. Fixed my answer. Thanks
  
  – IgorM
  Mar 23 at 16:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You could also use iif(datepart("q", datecolumn)=1, Salary, 0) etc. as an alternative.
  
  – Lee Mac
  Mar 23 at 16:43
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @igorM... I think, you could not understand my issue.. i can group query but issue is to put up 3 months row fields to three columns in single report.. each report for each employee.. see images
  
  – mukeshesic
  Mar 23 at 18:09
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @user2245124 the easiest way to pull out the months is usually a crosstab query. get everything else done then make the bottom of the report a sub report and bind to a crosstab query. There are lots of tutorials online under crosstab and access
  
  – mazoula
  Mar 25 at 5:15
  

  
  
  
  

 | 
show 3 more comments

You can implement the following SQL query to a salary per employee per quarter considering that your table contains only one-year salaries

 SELECT
 EmployeeName
 ,SUM(IIF(Month([DateColumn]) BETWEEN 1 AND 3, Salary, 0)) AS Salary_Q1
 ,SUM(IIF(Month([DateColumn]) BETWEEN 4 AND 6, Salary, 0)) AS Salary_Q2
 ,SUM(IIF(Month([DateColumn]) BETWEEN 7 AND 9, Salary, 0)) AS Salary_Q3
 ,SUM(IIF(Month([DateColumn]) BETWEEN 10 AND 12, Salary, 0)) AS Salary_Q4
FROM TblSalary
GROUP BY EmployeeName 

share|improve this answer

edited Mar 23 at 16:16

answered Mar 23 at 16:07

IgorMIgorM

489517

 SELECT
 EmployeeName
 ,SUM(IIF(Month([DateColumn]) BETWEEN 1 AND 3, Salary, 0)) AS Salary_Q1
 ,SUM(IIF(Month([DateColumn]) BETWEEN 4 AND 6, Salary, 0)) AS Salary_Q2
 ,SUM(IIF(Month([DateColumn]) BETWEEN 7 AND 9, Salary, 0)) AS Salary_Q3
 ,SUM(IIF(Month([DateColumn]) BETWEEN 10 AND 12, Salary, 0)) AS Salary_Q4
FROM TblSalary
GROUP BY EmployeeName 

share|improve this answer

edited Mar 23 at 16:16

answered Mar 23 at 16:07

IgorMIgorM

489517

answered Mar 23 at 16:07

IgorMIgorM

489517

answered Mar 23 at 16:07

IgorMIgorM

489517