Data Items vanishing on Report save

[fenfool]

I have a meeting database...one table has individual meeting information, a second has information on the meeting series...so all the meetings are part of an annual series, one table tracks the meetings, the other has higher-level meeting series info. The meeting series table has a field for the committees involved. This could be none, it could be all 13. The committee names are pulled from a third table.

This works great, except I've run into a problem with reporting on the committees. The data is fine in the tables. I built a query, everything is fine there...I built a report, everything looks fine there until I save it. As soon as I save the report, the data in the committee field is blanked out completely. Building a report, I can see the names of each committee listed, as expected, but saving it seems to break something in the report.

Does anyone have any idea why this could be happening? As I said, everything is fine up to that point, the other fields from all involved tables show up fine on the report, just that one field. It is a one-to-many relationship, could that be the problem...and why would saving the report break that? Any thoughts are appreciated, I'm stumped.

 

[boblarson]

Post a copy of your database so we can see.

 

[fenfool]

And now they are back. I THINK I found the problem, if I can't, I will post later today. I've just never heard of saving a report being an event that can change it! I'll dig some more, I have a feeling it was the query I was using.