none
Is there a way to query bill amounts by due dates? RRS feed

  • Question

  • I want this as a result, is there a query such to do it?

    supplier code     under 30 days     between 31 and 45 days    Over 60 days due

    1                           $550                        $1,125                              $856

    2                            $709                        $544                                $32


    Larry Nunez

    Wednesday, March 13, 2019 7:56 PM

All replies

    1. You can create a temporary column and to put (for example) a letter to identify what period belongs to
    2. Then, totalize it by vendor + temporary column

    Wednesday, March 13, 2019 8:03 PM
    Moderator
  • Looks like a crosstab to me. You'll have to encode the periods and then use you can run a crosstab generator. Here's my article about generating crosstabs: http://www.tomorrowssolutionsllc.com/Articles/Generating%20crosstabs%20in%20VFP.pdf

    Tamar

    Wednesday, March 13, 2019 8:29 PM
    Moderator