In need of help generating a report.

[aldo]

Is there a way to set up a query/report to display rows numbered 1 to max(AccountSize) and display the Count(AccountSize) that match the row number even if they are zero quantities?

I'd appreciate any help I can get.

Thanks much,

aldo

 

[lightray]

Hi aldo,

Yes it is. I'm pretty sure you'll find it in the way you have joined the tables in your query. you need outside joins, they will retun a 0

 

[aldo]

Thanks lightray.

-aldo