Report asking question not defined in query

[Kbaz]

Hi All,



When running a report, I have set it to ask for date parameters but its also asking me another questions and I am not sure why.

Sac rating refers to the Severity Assessment Collum.

I do have a list of IIF queries in the report, would that do it?


Please see attached query, report question and IIF queries on report

[ranman256]

usu its because of a field in the query that doesnt exist,
or misspelled,
or in the report, there is a GROUP that no longer exists so you get the param box.

note: its best to put all the IIFs in the query, so the report need only show existing fields, but you can do it in the report.

[Micron]

Or in the report there is an expression that isn't present in the report recordsource. I'm guessing your control names are what's seen in the labels and none of them have Sac Rating. Unless it's just not visible in your pic, that's likely your issue. Your naming convention is going to constantly present problems for you. Suggest you visit

https://access-programmers.co.uk/for...d.php?t=225837
http://access.mvps.org/access/general/gen0012.htm
http://allenbrowne.com/AppIssueBadWord.html