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

Its ok. Figured it out. Thanks again.

I have just one more question relating to this. Is this function limited to two special characters or can I add more. I tried to add some more and I get an error.

CJ_London. That's perfect. Thank you so much.

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

After further research the answer is below. This will work in a passthrough query, querying an Oracle database. Very useful. Cheers Ian SELECT TO_DATE('2010-01-01','YYYY-MM-DD') + ((LEVEL - 1) * 1) start_dt , LEAST(TO_DATE('2010-01-01','YYYY-MM-DD') + ((LEVEL - 1) * 1) + 9 ...

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

I have figured it out. I am referring to the wrong table Sorry 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...

Thank you so much, It works Cheers Ian

Hi Uncle Gizmo, The precedure works fine in my test database. I then moved the code to the live database to the open form event and I keep getting the error Compile error: User-defined type not defined Then the following code is highlighted in the function Dim DB As DAO.Database Any...

Uncle Gizmo, YOU ARE AWESOME!! Finally got the zip file opened. Incorporated what you wrote into the database and it does exactly what I need it to do. I have one or two tweeks to the functionality of the database but this is terrific. I can see other applications for method too. Once again...

Hi Uncle Gizmo, I understand your table design reference however I am stuck with it at the moment. I also cannot open the zipped file as I can have winzip on my computer. Can you reattach the file unzipped? Also, can you recommend any good training material for VBA. I am very new to this and...

Hi Uncle Gizmo, I'm going to need quite a bit of help on this one. Where do I place the code? Do I need to include this as part of the Events in the report? Thanks Ian

There you go

Hi Uncle Gizmo, I have tried what you suggested and I do like this idea. Here is the Function that seems to work when I run it in the Immediate Window. Function addfournumbers(Indy As Integer, Carmel As Integer, Stress As Integer, womens As Integer) addfournumbers = Null + 2 + 3 + 4 End...

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