Report antics

[Quiggle]

Hi all,

For my understanding of reports, they are a way of representing what is stored in the forms and tables, and they kind of just copying into a form containing what the user wants to see at that time.

The problem I have is that I have a calculated field which works brillently in the form and table, but when I put it in the report it just produces 0 when that is not the answer. i created the report by using a wizard, and I can't see why it would do that.

has anyone had this problem before and what was the outcome?

Thanks

Quiggle

 

[Quiggle]

Ive just had another look and my table doesn't show the correct value either, ubt I can't seem to put my calculation which works in the form text box anywhere on the table view.

If I can find out where to put it, it will make my report turn out correctly.

Anyone know where my simple calculation should go?

 

[Michael J Ross]

You can't put calculations in tables, you need to do it in a query.

Where you put your claculation in the report depends what it is calculating, totals etc can go in the headers/footers, calculations such as mutiplying a price and quantity would go in the detail section.

 

[Quiggle]

thanks for the reply, Its just a simple calculation to compare to dates and output how many days something has taken. It works fine in the form, but I can't get the query right either.

 

[Michael J Ross]

It should work ok in both the query and report. For what ypu are saying you should be using something like =DateDiff("d",[first date],[second date])

 

[boblarson]

Also, 2 other things:

1. Make sure your control names are different than the field names.
2. When doing calculations on a report, you don't have to have the calculations done in the underlying query, but you must reference the FIELD names and NOT the control names in your formulas.