Search results for query: *

How do I enter multiple conditions in one formula? Here is what I have. It only uses the last if/then in the formula. if CStr({tbl_Item.Amount2})=" " and ({tbl_Promo.Scan}> {tbl_Item.Amount}) then formula=({tbl_Item.Amount}*{tbl_Qty.Qty}) end if If{tbl_Item.Amount}=CCur(0.00) then...

I need a formula that will multiply a different variable to a field based on the owner of the product and a specific date range. I am using some fields from access that are a date/time field. I'm trying to convert them to a date field. This is what I have so far. There are no errors in the...

I am bringing a calculation into a main report from a subreport with the following formulas: Formula in the subreport: WhilePrintingRecords; Shared CurrencyVar myTotal:=Sum({Orders.Order Amount}) Formula in the main report: WhilePrintingRecords; Shared CurrencyVar myTotal; myTotal My problem...

How do I get the values in the parameter to automatically refresh? I don't want to have to import new default values everytime I refresh the report.

How do you create a parameter for a formula field? My formula field is (unit cost*qty) which creates a total cost. An example would be the user wanting to filter out any total cost under $100?

How do I add multiple parameters for different fields so the user may choose just one criteria for one field? (So, they wouldn't have to choose 3 criterias) For example, they would want to filter the report {field.color}= red & sometimes they would want to filter it {field.date}> 1/28/07.

I'm looking for a way to print the record closest to the current date without using a parameter. (I don't want a parameter because this will eventually be a subreport.) Example: The last date a product was produced.

How do I get a calculation with a division by zero to show without an error?