Search results for query: *

I have an query that updates the cost of items with criteria. However only part of the criteria is working. It looks at both the line type and item number and updates the cost. While Access is correctly using the line type it ignores the item number part of the criteria and updates the cost on...

I am trying to update records in a table. The code I have created returns two errors. One that "UPDATE" is not defined and an Expected ) referencing "In". Here is the code. ANy help is greatly appreciated. Function Cost() Update ARInvoice Set [ARInvoice]![SOUnitCost] =...

Using MS Access 2007. Have a form open with information. Also have an attachment field. Have a button setup that will send out a report based on the information on the form as a PDF attachment. In addition also need to have as an attachment to the e-mail the PDF that is an attachment to the...

Is it possible to format text within a formula? Let’s say I have a formula: “24 Months” +chr(13)+chr(10) @24months And I want the text "24 Months" to be bold and underlined. Results would be: 24 Months $500.00

Have a report in which the first group is by Branch, the second group is by Salesperson, the third group is by Customer and the last group is by Product Categories. The totals include sales this year and sales for last year. Some items and customers will have zero (0) sales for this year and...