Recent content by Delius

A database I'm using has 2 main tables I need to work into a query: one for Product Information and one for Discounts applicable to the product's normal price. There are two types of Discount, and for each I have set up a Query to calculate the final price of the product. The procedure I now...

Thanks very much indeed - all working now.

Re: Trying CSng is just giving me error results - seems it requires a purely numeric field, whereas I need to extract (for example) the "3.2" portion of an entry of "3.2%". :confused:

Re: Thanks both, I have ended up using the Val() function; however this is only working across 95% of my data, since it turns out not every field is #.0 and where I have a decimal value other than zero (e.g. 3.1%) Val() returns Error#. I know I said previously that the figure after the decimal...

I can't help but think that this ought to be an easy one, but I just don't know how to achieve it: I have a linked table within my database, the source table for which contains a field called Disc%, and the values for this field are in the format #.#%, e.g. 5.0%. I need to use this number in a...