Search results

Hi, Could anyone please asssist with the syntax to format a field value as percent to two decimal places in a make table query ? I have the field format set to percent via the properties and the query displays percentages. However when I run it to make the table it creates the table with...

Hi, Is it possible to have an SQL query that obtains field values from a table in another MS Access database, if so, could anyone please assist with the syntax required for the FROM clause ? I have tried various options to try to reference the other database using path locations on my hard...

Wayne, It works a treat. I have just realised that I caused a bit more confusion earlier by having the ID Key names as [TrkDstKey] in one table and [TrkDistKey] in another table. However, your capitalising the i in the code highlighted the disparity. Many many thanks for sorting this out...

Wayne, I edited the name of the module from GetBand to m_Fct_GB and the query actually runs and returns values so that has cleared up the Undefined Function issue. However, although the query is running, it is allocating the wrong [TheBand] values to the [CT] values. A quick check on what...

Wayne, Thanks for the reply. I set up the module and query but I am getting the undefined function error message when running the query. I may have set up the module incorrectly as my skills with VB are very poor. My procedure was to create a new module and paste the code into it then save...

Hi, Could anyone please assist me with a query that I wish to set up. The basis of which is to find the nearest value in one table to a specific value from another table. In a table named [Source] I have a field named [CT] which contains a series of numerical values. In another joined table...