iff statements

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

Guest

Where can I find information on iff statements and if I can use it in the
case. What I am trying to do is design a report that will be populated with
sum values of data by month. However, if the month has not occurred as yet
and there is no data to populate the field, the months do not show up on my
report. I was thinking of putting an if statement in the text box on the
report that would say if the sum of Jan is blank then enter 0.00., if not
blank then enter the sum of Jan. How can I make this work? If an if
statement can work in this case, please let me know how to write this one and
maybe where there are examples of these. I have written numerous if
statements in Excel but the format doesn't seem to work in Access.
 
Do you have a column named Jan? What are your fields? Are you wanting to
create a record in a record source where there is no record?
 
This database tracks the money contributed by church members each month.
Then there is a report that shows the total donated by month. I created an
expense crosstab query that sums the total contribution by category by month.
However, if the month has not occurred as yet, i.e. we are in January so
there are no contributions for February, then the reports produces errors and
the totals do not calculate. So in conclusion the report shows all the
months of the year in columns and the rows are the contributions by category
(tithes, offerings, building fund, etc.) I cheated and put in a Void
category and for each month I put in a 0 in that category so the report would
sum all the months an show them. I really don't want to show a void category
and I was hoping to write an if statement like if(sum(jan)="",0.00,sum(jan).
 
You can set the Column Headings property of your crosstab to:
Column Headings: "Jan","Feb","Mar","Apr",...."Dec"
 
Back
Top