(Access 2000/Windows 98)
I have a report whose record source is a query that is made up of several other queries. It's slow, but it works for what I need, which is to combine information from several tables so that I end up with 1 row for each of my "positions".
In the process of trying to write some of the queries to make them run faster, I added a field to the output that was the "sum" of a field available from a previous query. Now when I use that field in the report, it comes up with an "Enter parameter value" box when I preview the report.
If I open the query that is the record source for the report, I don't get any errors or prompts, and all information is valid.
I've gone back through from the beginning but can't find anywhere this would be coming from.
Is there a special way I have to reference this in the report itself since it is not a native field from a table, but an expression created in one of the queries with the 'sum' function?
I have another field that was already being used that is identical to how this was one created, and don't have any problem with it. The only difference I can see with it is the control source for that field isn't set directly to that field, but set through an IIF. But it does work fine.
Any insight, or suggestion on where I could look for more help would be greatly appreciated. I'm using Access 2000. I've checked Access' help about the parameter queries, but their possible culprits don't fit.