calendar Reports

  • Thread starter Thread starter zotos
  • Start date Start date
Z

zotos

Hi,

I need to create a reort that simulates a calendar report that displays the
dd and the orders processed that day and their value. In the event there are
no orders I need to generate a $0.

Can someone tell me the table data I need and the formula in the costtab
query that generates a 0 when no data is present please
 
Hi,


When no data is present in a line, but the column is present:

TRANSFORM Nz(SUM( fieldName ), 0)
SELECT ...

Assuming you want a SUM.

If you wish the columns to be present, you need to use the Column Headings
property to specify all the columns you want to get (and you will get ONLY
these).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top