Pull In Data for Some Fields & Some Leave Blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report in Access that shows the September Actuals and they are being
brought into the report via Visual Basics. In the report we have a query
that sorts all the items by BCSPerspective. One of the BSCPerspectives,
Customer, does not have September Actuals. How can I write code so that it
pulls the actuals for the three other BCSPerspectives and leaves the Customer
one blank? Currently it shows 0 and we don't want to see anything there at
all.
 
Set the format property to not display zero values. You can check Help on
format of numeric values for some samples.
 
Back
Top