0 and spacing

[NetworkTrade]

A simple report will have: Name - - - Week's Sales - - - YTD Sales

I can get the correct values easily enough in 2 separate queries;
1. Name - - - Week's Sales
2. Name - - - YTD Sales

and could just put 2 subReports side by side...

But in some weeks a name will have no sales value - even though they have a
YTD value....and there is no 0 value in that query result of course because
it is returning a sum of sales by name for that week, thus the side by side
spacing of the two subReports goes off...

Any tricks of the trade for this type situation?

thanks NTC

 

[Duane Hookom]

Create a single query and use join properties that include all the records
from a table or query that includes all "names". You can double-click a join
line to display the join properties.

 

[NetworkTrade]

yep thanks - had casually tried that approach but didn't define the join - -
and it works fine...

still of course don't get a $0 when there is no data for a name....just a
blank field ; having a $0 is more a window dressing item than
factual....but...

can one insert a 0 somehow using the OnFormat event? something like;
If [WeekSales] IsNull Then
[WeekSales] = 0

not sure if that will fly.... not so important really though....

 

[Duane Hookom]

There are several methods for doing this. You can use Nz() in a number of
different places or set the Format property of the text box in the report to
display 0 if the value is null.

--
Duane Hookom
Microsoft Access MVP

yep thanks - had casually tried that approach but didn't define the join - -
and it works fine...

still of course don't get a $0 when there is no data for a name....just a
blank field ; having a $0 is more a window dressing item than
factual....but...

can one insert a 0 somehow using the OnFormat event? something like;
If [WeekSales] IsNull Then
[WeekSales] = 0

not sure if that will fly.... not so important really though....

--
NTC

Create a single query and use join properties that include all the records
from a table or query that includes all "names". You can double-click a join
line to display the join properties.