Search results for query: *

Thanks, PHV. It's working.

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...

Yes, I do.

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...

Sorry, I think I'm not just updated with the different Cognos products. Just found an answer through a sample in one of the internet sites.

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...

Got an idea from another forum, applied to my project, it worked. Here it is: strsql = "SELECT * INTO " & MyLocalTable & " FROM [ODBC;Driver={SQL Server};SERVER=MyServer;DATABASE=MyDatabase;UID=MyID;PWD=MyPwd].MyTable;" strTableName = "tblSourceTable" If TableExists(CurrentDb...

Actually they are string and I understand they should be entered without the single quote. The data source is entered as Data Source =MySource.OurCompany.com Any thoughts? Thanks.

I've experimented on several options to copy a table from an external database into my local Access table. After so many attempts and internet searches, my efforts were unsuccessful. So far the script below looks promising as it's only giving me "Invalid Argument" error. Please help as I'm quite...

After getting ideas from different sources in internet, I finally came up with the following which is working for me. Just in case it will help others too. INSERT INTO tblTwo SELECT * FROM (SELECT RecType, Code1 As CodeOne, Code2 As CodeTwo, Left(YR,4) + '01' AS Period, Per1 AS Amt...

I have an SQL table (tblOne) created through DTS with the following columns: RecType, Code1, Code2, Month1, Month2, Month3, Month4, Month5, Month6, Month7, Month8, Month9, Month10, Month11, Month12. It's the same layout from a source table in a different database. Now I want to have another...