Search results

I have a query in Microsoft Access 2010. A couple of columns have a number that needs converted to 2 decimal places. This means that the number to convert will be a variable depending on the value in the column. Can anyone help me create this function. Thanks Ian

Hi there, I have an issue with a column in my query where I want to remove special characters. I have created the following function to use now and other times also. Public Function con2(DESCR As String) As String Special = ("[") con2 = Replace(DESCR, Special, " ") End Function The...

Hi, I have a query result in datasheet view that looks just fine. However, when I change the view to Pivottable view I do not get the right summary result. This is due to the pivottable rounding the numbers. Has anyone had experience of this and do you know how to fix this in order to...

Hi, I am having an issue with my query. When I link all of my tables together and run my query I return the lines I need. However, When I narrow down the search - for example- PO_Date then I get the following error mesage in the fields after the query has run #Name?. If I take this same query...

I am using a passthrough query that queries an Oracle Database and I want to be able to have a list of the next 30 days dates. Does anyone know how to do this. I have an SQL query for listing the same day for the next few months but am struggling to get it to days. See below. SELECT TO_CHAR (...

Hi, I have a report that uses a form to enter date parameters for a report. I would like to able to show the dates entered into the form on the report using VBA. Can anyone help? Thanks Ian

Hi, I have an update query in my Access 2003 database. I want to update three columns based on the Project_Number. However, the query will not update all of my records even though there is info to update from. I have 390 records to update but it will only update 350 of them. Has anyone came...

Hi, Does anyone know of a simple way to stop a report in Access from printing if the underlying table has a Null Value in it? I have a report that references a table with six columns. First two columns are text and the next four have revenue figures. The 4 columns each refer to an entity. I...

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

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

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

Hi, I have a report that has an underlying passthrough query. I would like to be able to use a form to input the date and then pass the date entered into the form to the query and then run the query. I have seen this done before but unfortunately I didn't take notes. Can someone help...

Hi, I am in the process of building a database in Access 2003. I am trying to update a table to replace all of the Null values in number formatted fields with zero. I thought about updating one column at a time but that does not seem to be efficient. Does anyone know of a way to do all...

Hi, I have a list of services that pertain to a client ID. One record for each service with a date the service was performed. Does anyone know of a piece of VBA code that will concatenate all of the service dates for each client, create a new table and list the result by Client ID based on...

Hi, I have a list of services that pertain to a client ID. One record for each service with a date the service was performed. Does anyone know of a piece of VBA code that will concatenate all of the service dates for each client, create a new table and list the result by Client ID based on a...

Hi, I am trying to upload information into a Lawson Database. The Form has a function but I am having trouble fuguring out which control ID it is. The regular upload interface add-in doesn't support the Load button. Can anyone tell me which part of this code refers to a button control? I...

Hi, I have a file that has a field that contains both company name and numeric data. I have tried parsing the data in excel but the company name has multiple words with each word separated by a space. I cannot figure out how to replace the spaces between the company name words with an...

Hi I am trying to hide zero values in a pivottable in excel. I have tried the following code but can't seem to get it to work I have a row field of "Project_Number" and a column field of "Year" and a page item of "QTR". The value is "Sum of OPEN_PO_AMOUNT" I have some values that are...