Replies

I’m sorry. I guess I didn’t explain very well. When I saw that the 3rd field wasn’t being displayed in the combo box, I went in and wrote a new query to test it, and I get the same results. Right out of the query window. At this point I’m not even looking at the combo box, just the query results. Thanks.

I just found my problem. As I was working on something else I found that I was changing the report’s record source in the “on open” dependent upon a field on a parameter form. So even tho I could see the correct results when I ran the query, that query wasn’t the one being used when the report formatted. No wonder it didn’t know what field I was talking about.

Sorry to waste your time. I tried to look everywhere before posting, but just didn’t catch that one. Thanks for your help anyhow.

Thanks for responding. I’ll try and explain a little better.

I already was using a totals query that had an expression I named “SumOfYL” which is the sum of a field named salary_expended. Within in the same totals query (could that be my problem??) I added another expression called “SumOfSalaryEn” which is the sum of a field called salary.

Originally, I allowed it to name it SumOfSalary as you said,but I was using “SumOfSalary” on the report and not just “salary” to reference it. When I changed the expression name to “SumOfSalaryEn” I still get the parameter box when I try to preview the report.

I think I mentioned before the field that I had summed originally works fine in the report. I believe I am doing exactly the same thing for this other field, yet I get the parameter box.

I hope that makes sense. This isn’t an example of a typical query that I work with, because they don’t ususally involve all of these other queries as tables. If you don’t have any suggestions, I’ll just put it back to a dlookup. Thanks for any input or suggestions you may be able to provide.

As far as I know you can go 3 layers deep. I’ve done it that way before and didn’t have any problems.