Adding a calculated field to report

[Danr94]

I'm very new to Access and I'm having a very difficult time converting over from FileMaker Pro. It seems that Microsoft doesn't like making things easy! I'm trying to add a calculated field in a report. It's a simple If-Then statement :=IIf([WS Data]![Days Passed Sold]>10,"DSSM",IIf([WS Data]![Days Passed Sold]>5,"DSOM","WSA")) When I run the report I'm presented with a window titled "Enter Parameter Value" then below is the table name "WS Data" and below that the empty field. I have no idea what I'm supposed to enter so I enter nothing and click OK. When the report is displayed the field has the following error: #Type!. What does this mean? The WS Data is linked to an excel spreadsheet so adding a calculated field to the table is not an option (although I know if I added the same calculations to a field in the table, it would work - go figure). Any help here would be much appreciated. Thank you!

[Minty]

Put the calculation into the reports underlying query. It's more efficient and easier to debug.
I assume WS Data is joined to the other data in the query?

[Danr94]

There are no queries. This is a very simple database with a letter and summary report in which the WS Data is used in both. The dealer data table is only used for addresses in the letter report. I probably don't use queries as much as I should. Should I create a query just for this field?

[Minty]

Yes - press the builder ... on the datasource for the report.

[Danr94]

Thank you for you're help. It took me a while to figure it out but it works. The query doesn't show in the list. It must be saved within the report? Also, when I built the quiry I found that all the fields used in the report must be in the query. As I said, I'm new to this and I really appreciate your help!

[Minty]

You could use a saved query, but if you forget that that is being used for that report and change it you may break the report.

[Danr94]

Right! I've had that happen before, Thanks again for your help. I learned something today!