0

Item list from 2 periods

Jet Reports Historic Posts

August 28, 2012 11:17

None

Follow

Maybe somebody can help me with this situation.

I would like to get a list of all unique Items sold in 2 different periods

Example:

Table: Item Ledger Entry
Field: Item No.
Posting date 1: 01/01/2012..31/01/2012
Posting date 2: 01/01/2011..31/01/2011

This should give me an efficient way to only get the sold items in 1 or both periods and not all sold items wich i want to use with a NL(rows function.

Thnx in advance

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts August 28, 2012 17:23

  Hi,
  
  You can just use the filter "01/01/2012..31/01/2012|01/01/2011..31/01/2011" for the Posting Date field. Does that make sense?
  
  Regards,
  Hughes