Recent content by debq

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

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

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

Thank You!!! That worked perfectly!!

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

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

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

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

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

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.

I added in all of the missing Parenthesis.... There were many... Now I am getting the following error: "Syntax error in FROM clause" MS Access is highlighting the semi-colon at the end of the statement. This is the current code: SELECT t1.companyid, t1.mASter_clientid...

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

I have been given a SQL statement to adapt for use in MS ACCESS 2010. The SQL statement was written in SQL Server so I understand that there will be differences in syntax. I have tried to adapt the query for MS Access but am getting the following error: Syntax error(missing operator)in query...

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

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