Search results for query: *

PHV - You have been very helpful - and patient. It is working great now. Thank you so very much!!!

PHV, I sure appreciate your help. I joined the taxrate table in the query and the field for taxrate now shows the correct taxrate, however, the calculation is still using the primary key field when computing taxamt. I'm getting frustrated and imagine you may be also...

PHV, Yes, table is named TaxRate - it appears to be retrieving the taxid from the 1st column of that table instead of pulling from the 2nd column which is the actual tax rate. Is there a way to point to the 2nd column? Thanks again...

PHV, I re-did your suggestion RealTaxRate: 1.0*[TaxRate] CurrTaxRate: CCur([TaxRate]) when I run the query, I get 1 instead of .06. I went back to my form, and this field is listed as a combo box that lists valid tax values (to prevent user errors). Perhaps this is the problem? Is there a...

PHV, If I use your suggestions RealTaxRate: 1.0*[TaxRate] CurrTaxRate: CCur([TaxRate]) I receive error - invalid syntax. Thanks...

My error: fields are Qty, UnitPrice, TaxRate. Not using Sql. Thanks...

It seems like it's a problem with the taxrate field. Calculations work unless I am using the taxrate field. I tested the calculation by using just the qty field and the tax rate field and the tax amount came out as the same number as the qty field. TaxAmt: CCur([qty]*[taxrate]) My tax rate...

Thanks for your reply PHV- I tried TaxAmt: CCur([Qty]*[Unit Price]*[TaxRate]) as you suggested - and it still shows up as $25.00 for the tax amount on a $25.00 purchase. Any other ideas?

I have a problem with a calculated field on a query for a purchase order. Fields include Qty, Unit Price, Tax Rate. I have created calculated fields in this query that work fine - Item Subtotal (calculates qty * unit price), and Item Total (adds item subtotal and tax amount). My problem is...

In Outlook 2000, when I receive an email with several attached files, I can go to file/print and check print attached files so all attachments can be printed out without individually clicking on each attachment to print. In Outlook 2002, the print attached files in the print dialogue is...