1. Home
  2. Point-Of-Sale Software
  3. report

report

I hope this question hasn't been asked before and I just didn't see it. I am tweaking a sales report for a client. I need the report to show sales for item number either 100 OR 200. When I use the filters below the report shows a filter of Date Sold Between 6/30/2009 and 6/30/2009 AND Item = 100 AND Item = 200. How do I get it to be AND Item = 100 OR Item = 200?

//--- Filters ---//

Begin Filter FieldName = "[Transaction].Time" FilterOp = reportfilteropBetween FilterLoLim = "" FilterHilim = "" End Filter

Begin Filter FieldName = "Item.ItemLookupCode" FilterOp = reportfilteropEqual FilterLoLim = "100" FilterHilim = "100" End Filter

Begin Filter FieldName = "Item.ItemLookupCode" FilterOp = reportfilteropEqual FilterLoLim = "200" FilterHilim = "200" End Filter

Reply to
Sammy
Loading thread data ...

Sammy,

Try this:

Date Sold Between 6/30/2009 AND Item = 100 OR Date Sold Between 6/30/2009 and 6/30/2009 AND Item = 200

Marc

Reply to
Marc

Reply to
Sammy

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.