subtoaling a report based on Criteria from Form

C

C Brehm

Tbl [Vendor]
Fields: VenNum (integer,0), SubVenNum (Boolean),
Inventory (Boolean)
Tbl [Sales]
Fields VenNum (integer,0), SubVenNum (integer,0), Date, Description(Text),
InvNum (integer,0),Price, Qnty (integer,0), WeekEnding(date), Paid (Boolean)

Form Contains One text box and One Button To Run Report and One to Close,
User puts in ven number and code on Button checks Vendor record to see if
they
1. Use Inventory Numbers
2. Use SubVenNum
3. Does Both
4. Does Neither
Depending on answer is which report to Run ( Wish I could figure out how to
do it in One Report)

Problem I am stuck on is:
Report runs For all records for this vendor Before the Saturday (WeekEnding)
before Today that have not been Paid.
If They Use SubVen Numbers, I need to Group Sales, Sorted by Date based
on SubVenNumber and Subtotal each Section (If they use Both then further
sort by Inv Number) By SubVenNum.

Then A total at the End Of Report.

Do not want a separate page per SubVen Num as there may only be 1,2 or 10
Records.

Thanks in Advance
Carl
 
Top