Search results

Hi, We are talking excel. The columns are already in the worksheet but I am pulling data from a worksheet and want to give the calculated columns a heading name. Here is the code. SELECT `'Cur Bud Data$'`.Concatenate, `'Cur Bud Data$'`.Leader, `'Cur Bud Data$'`.Cost_Center, `'Cur Bud...

I've tried that also but it still doesn't hold the name.

Hi All I have a query in an excel workbook that references another sheet in the same workbook. The query is fine but when I create a new calculated column within the query I would like to give it a name. I have tried : for example AS "ColumnName" and different permutations of this but it...

Figured it out, In order to subtotal the appropriate columns the numbers in the code need to be changed. The [CODE]For I = 8 To FinalCol [CODE] needs to be 1 more than numbers in the following lines. [CODE]TotColumns(1 To FinalCol - 7) [CODE] and [CODE]TotColumns(I - 7) = I[CODE] As you...

I've attached a sample of the workbook Thanks Ian

Hi I have some code below that inserts a subtotal at the breaks I need. However. I can't seem to get it to be specific to the columns I want to subtotal. I have tried changing the numbers in For I = 3 To FinalCol with no luck. I also want it to exclude the Grand Total row with no luck. I...

Thanks, I'd appreciate that very much Ian

Thanks Chergh, That works. Do you have any insight into how I would then add subtotals using VBA? Thanks Ian

Hi, I think that is the issue. I'll see if I can go from here. Thanks Ian

Hi Here is the code I have. This is from a previous post and is what I really want it to do in order to insert lines but it does not seem to work. Is there something missing? Sub InsertRows() Sheets("MainViewTest").Select ' adjust sheet name as necessary For lRow = lLastRow To 2 Step -1...

Hi I have a set of data in a spreadsheet that I want to insert a 2 blank lines and then subtotal the data each time there is a change in value in column F. I then want to grand total at the bottom. I would like to be able to do this using VBA as the subtotal function is not appropriate for my...

Hi, After further investigation - The CanGrow property in working on some records in the report but not others. Really strange and haven't a clue why it would do this. As anyone had issues with this before? Thanks Ian

Hi datAdenaline, I've set the section and the fields in the report to CanGrow = True. Still not working. Is there a way to set this into the VBA? I have this code in the OnFormat Detail section of the report. This looks at the Date field in detail section and then concatenates the dates in a...

I think you are correct with the floating decimal point. If the original text file is set to space delimited then I keep having this problem. If the file is set to tab delimited then I am able to import the file and have the formats work the way I want them to. In short - it looks like I need to...

Still getting the same. I've even tried rounding the field before I imported it into Access from excel

HI, I have a table in my access database that has zero values. When I query the table I get zero values in my query but they are not really zeros. I have the column in the base table formatted to Double. They seem to have many decimal places after then when I click in the column. So, if I want...

Hi dataAdrenaline, It is a report that I am trying to print. I have the detail in the report but when there are more than 3 items it cuts them off. Is there a piece of code to have the field expand in the report to show all of the concatenated detail? Thanks Ian

Thanks, I checked out the link at now I can do exactly what I wanted. The only piece that I can't get to work is the Can Grow property. Thanks Ian

Hi, Does anyone know of a way to filter a file on import into Access. I have a CSV file and I want to be able to filter the report to exclude records with a zero value when I import into Access. Thanks Ian

Thanks for your help. The QueryDefs is helpful. I have taken a slighly different approach by using a template for the query that works very nicely. I now have a form that I can enter the date in and am now able to change the query based on the date I have chosen. Thanks again. Very helpful...