Search results

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

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