Sorry, the entire query is:
SELECT A.Employee_Name, A.Employee_ID, A.PayDate, A.Hours, B.COMPRATE FROM qSQL_Pay_Records A inner JOIN (Select EMPLID,COMPRATE,MAX(EFFDT) From qSQL_Job_Pay B GROUP BY EMPLID,COMPRATE) B on A.Employee_ID=B.EMPLID
Hi AlexUse,
I'm in similar situation as netrusher and your solution is leading me to the right direction. My query is suppose to get the latest payrate of an employee from a rate table. Unfortunately the query is giving out more than one result (rate). The second part of the query look like...
I have a form with several combo boxes. The selection on the first combo box determines what data is retrieved by a pass-thru query which are then used to populate a table. The subsequent combo boxes are based on a query that grabs data from the just populated table. It's when the second combo...
We are using PeopleSoft 8.44 for our Requisition/ Purchasing, Accounts Payable, General Ledger and Payroll. In purchasing, our inventory and non-inventory items (services) have tax defaults (rates, non-/taxable). Unfortunately, a lot of these items are either non-taxable or have different rates...
Got it! One last, little thing. How do I make the column total movable so it will be right after the last month column?
Thanks again, here's a star for you!
The header is now taken cared of. Thanks for the tip. Now, I still stuck with the details. I tried putting a condition say for Month6 with total months selected is only 5, IIF(totMonth>=6,[Month6],""), and so on with months 7 to 12. It's giving out error msg "The Microsoft Jet database engine...
You're guess it right, I'm using cross tab query. For testing purposes, I created a cross tab query for Months 1 to 5 and make it as my record source for the report. The report has a layout with 12 months in page header and in detail. When the report is opened, it gives out error message for the...
I have a report with months 1 to 12 as columns in Detail section. What's the best way of hiding the columns 1 to 5, for example, if the desired information (input selection from Form) is only from Jan to May. Initially, I was thinking of use Select Case making each month visible only as...
What's the difference between Powerplay Web and Upfront? I thought once you published your PPlay report (created through PPlay Windows) to Upfront, that's the PowerPlay Web version. But then I read a Powerplay user's guide which says reports from Powerplay Web Explorer or Web Viewer can be...
Thanks, AlexCuse. Yes, it is a UNION query. I just left out the second part of it. The blanks will be useful when users will dump the results into Excel spreadsheet. When you say as BlankCol1, you mean ' ' as BlankCol1. So basically giving the column a name? Thanks, again.
My query looks like this:
SELECT Fld1, Fld2,'','','','','','','','','','','','',Fld13 FROM tbl_One
so that it will create 12 or more blank columns between Fld2 and Fld13. Is there a more 'professional-looking' query to get the same result? Thanks.
Our users are grouped by business unit, department, and project. How do we restrict users to access data in a cube only for their assigned business unit, department and project? A user can have access to one business unit but should be able to look into one or more departments and projects. Is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.