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 derfloh 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: debq
  • Order by date
  1. debq

    How to calculate the difference in the last two columns of crosstab varying number of columns

    Hi Ken, Thanks so much for your reply. My report has grown and become more complex. I still have the one row (Account Class) and one column (Admit month). I have a total of 6 summarized fields. I have a calculated member with the following Insertion formula: CurrentColumnIndex=5 The...
  2. debq

    How to calculate the difference in the last two columns of crosstab varying number of columns

    I have created a Crystal Reports Cross-Tab that calculates number of accounts per account class as rows and months per column along with other calculations. A total of 6 summarized columns per month. This is a very general overview of the cross-tab January February March Difference Mar...
  3. debq

    MS VBA DoCMD Transferspreadsheet - Use form data to choose excel sheet - HELP

    I think your code works because cboText is a String data type that is being concatenated or added to the string "!E9:P22". In my code I had the two pieces together as one continuous string and the system could not find that full string as a sheet name and Range in the excel spreadsheet. Am I on...
  4. debq

    MS VBA DoCMD Transferspreadsheet - Use form data to choose excel sheet - HELP

    Thank You!!! That worked perfectly!!
  5. debq

    MS VBA DoCMD Transferspreadsheet - Use form data to choose excel sheet - HELP

    I am trying to get the following code to use the sheet name that I choose on a list box in a DoCMD. TransferSpreadsheet path. The code works if I place the actual name in the path. But when I try to get it to read the cboText choice I get an error that it cannot find the object.Can someone...
  6. debq

    How to import Excel Sheets to Access. Each sheet to begin on Row 1

    I agree. I would never build data tables in this manner.... But I am pulling data from the "trusted" excel format and placing that data into a dashboard with a very specific format. I need the data to line up in a specific way so that I can reference it in my report by ID number.I am currently...
  7. debq

    How to import Excel Sheets to Access. Each sheet to begin on Row 1

    I have found a solution to open Excel, Choose an specific excel sheet based on input on a listbox form from a user and import the data from the selected Sheet to an Access db table. The data in the Excel sheet is based on months - Jan thru Dec. I can create the table with the months as column...
  8. debq

    Export Multiple filtered Subform data to one Excel Workbook

    I am using MS Access version 2010. I have a Main Form, frm_ClientPriceDetails with three(3)subforms: fsub_ClientDetail, fsub_ClientOrderCodePrice_Data and fsub_ClientSpecialPrices. I have a text box control on the Main form: txtClientID with Control Source set to...
  9. debq

    Nested SELECT Query giving Syntax error

    Ok...... I figured it out.... I broke my CODE into several small subqueries and then joined them into 1 main query.... Thanks for helping..
  10. debq

    Nested SELECT Query giving Syntax error

    OK... I have fixed the semi-colon and am stilll getting the same error: Syntax error in FROM clause MS Access is highlighting the second "LEFT JOIN" in the statement.
  11. debq

    Nested SELECT Query giving Syntax error

    ...AS FlatRate_FeeSchedule, t2.fingroup,t2.effectivedate, t1.perdiem_rate,t4.flatratediscount,t4.fingroup, t4.effectivedate FROM(SELECT a1.* FROM(dbo_SLAR_Client AS a1 LEFT JOIN(SELECT COMPANYID,MASTER_CLIENTID FROM(dbo_SLAR_Client GROUP BY COMPANYID,MASTER_CLIENTID ) AS a2 ON...
  12. debq

    Nested SELECT Query giving Syntax error

    The "AND" in the second "ON" statement is highlighted. Here is the section of CODE that MS Access is highlighting: INNER JOIN dbo_SLAR_clientdiscountfeeschedule AS y ON y.companyid=x.companyid AND y.clientid=x.clientid AND y.fingroup=x.fingroup AND y.effectivedate=x.latesteffective) AS t2...
  13. debq

    Nested SELECT Query giving Syntax error

    ...AS FlatRate_FeeSchedule, t2.fingroup,t2.effectivedate, t1.perdiem_rate,t4.flatratediscount,t4.fingroup, t4.effectivedate FROM (SELECT a1.* FROM dbo_SLAR_Client AS a1 LEFT JOIN (SELECT COMPANYID,MASTER_CLIENTID FROM dbo_SLAR_Client GROUP BY COMPANYID,MASTER_CLIENTID ) AS a2 ON...
  14. debq

    How to set WHERE statement based on two Criteria

    Ah Hah!!!! Perfect!!! Thanks for helping me so quickly... It always seems to be the little things that get me!
  15. debq

    How to set WHERE statement based on two Criteria

    I have a Query that SELECTS records based on a Percent. If the percent is Greater Than 40% then SELECT the record. Now this criteria is changing to SELECT Records after 08/31/2012 that are Greater Than 30%. I need to continue to SELECT Records with Greater Than 40% prior to 08/31/2012 and then...
  16. debq

    How to update one field on two tables immediatley AfterUpdate

    GREAT!!! That did it..... I knew it had something to do with single or double parenthesis... and data type number vs text.... I just could not get the syntax right... Thanks so much for your help and your patience.....
  17. debq

    How to update one field on two tables immediatley AfterUpdate

    The Audit Review Number is a Number and the field Problem_PA_Only is a text field. Thanks for your help!!
  18. debq

    How to update one field on two tables immediatley AfterUpdate

    Oh.... the field Audit Review Number is a number not text.......
  19. debq

    How to update one field on two tables immediatley AfterUpdate

    Yep... You are correct!! I have inherited this DB.... Lots of issues and problems... I was told to sync the field, "Problem_PA_Only" on both tables... (not in a position to ask why) so I am trying my best.... Yikes... and I am just learning VBA... I want to learn so as not to repeat the...
  20. debq

    How to update one field on two tables immediatley AfterUpdate

    I need to update only one text field on tbl02_Main_Table , "Problem_PA_Only". "Problem_PA_Only" is a text field on the form that updates to tbl01_Audit Reviews. I also need to update this field concurrently on tbl02_Main_Table. But I will only need to update the current record on the form...

Part and Inventory Search

Back
Top