Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jodjim
  • Order by date
  1. jodjim

    MAX DATE QUERY

    Thanks, PHV. It's working.
  2. jodjim

    MAX DATE QUERY

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

    MAX DATE QUERY

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

    Message: The data has been changed

    Yes, I do.
  5. jodjim

    Message: The data has been changed

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

    Best approach in Changing Tax default for each item

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

    Hiding number of report columns based on a value

    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!
  8. jodjim

    Hiding number of report columns based on a value

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

    Hiding number of report columns based on a value

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

    Hiding number of report columns based on a value

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

    Difference Powerplay Web and Upfront

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

    Difference Powerplay Web and Upfront

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

    Query that would create blank columns

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

    Query that would create blank columns

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

    Limit users access to data

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

    Copy Table using DSN less connection (part2)

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

    Copy Table using DSN less connection (part2)

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

    Copy Table using DSN less connection (part2)

    ...below looks promising as it's only giving me "Invalid Argument" error. Please help as I'm quite desperate already. Thanks a lot. strsql = "SELECT * INTO MyLocalTable FROM [Provider=SQLOLEDB.1;User ID=MyID;password=MyPass;Initial Catalog=MyDatabase;Data Source = MyDataSource;].MyDbTables;"...
  19. jodjim

    SQL pivot table

    ...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 FROM tblOne UNION SELECT...
  20. jodjim

    SQL pivot table

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

Part and Inventory Search

Back
Top