Report/Sub sections (1 Viewer)

[bwh1000]

I think that this is a silly question, but I can't seem to find an answer anywhere.

I am writing a quoting database, In the main table, I have a field for Qnty and then Option. The quantity is how many parts that are being quoted, but we would also like to have other parts listed as options for the client to consider. my query right now has a condition on it that is essentially if qnty>0 or option>0, then pull the data. That is fine. My only problem is that I would like the report quote to print out as:

Group1 = all qnty>0 (no option parts here)
qnty, item, etc.

Then a seperate section for all option>0 (no qnty parts here)
option,item, etc.

Can anyone give me a clue for a direction to do this?

 

[JHB]

Only a thought, couldn't you make a "Groupon" field in the query and then make a grouping on that field in the report?

Groupon:Iif([TheFieldNameForTheQnty]>0;"Qnty";"Option")